Hi,
sorry for the awful question title but i couldn't think how to put this simply.
I have a table full of records, many of which have more than one row with the same account number. If one row containing the account number matches a certain criteria I'd like to mark all records with that account number. e.g. account number 12345 has one record that has a column marked true, I need all records for 12345 to have another column marked as true.
I ran a query for all records marked as true (Qry_True_Test) and their file numbers thinking I could use a join on the two queries to test but it's marking all records whether or not they appear in the Qry_True_Test query.
I realise it would be more efficient to have all the account details stored in one table and the rest of the data in another. That's a whole different project for me though :D
Thanks
Nick
sorry for the awful question title but i couldn't think how to put this simply.
I have a table full of records, many of which have more than one row with the same account number. If one row containing the account number matches a certain criteria I'd like to mark all records with that account number. e.g. account number 12345 has one record that has a column marked true, I need all records for 12345 to have another column marked as true.
I ran a query for all records marked as true (Qry_True_Test) and their file numbers thinking I could use a join on the two queries to test but it's marking all records whether or not they appear in the Qry_True_Test query.
I realise it would be more efficient to have all the account details stored in one table and the rest of the data in another. That's a whole different project for me though :D
Thanks
Nick