K kirkm Registered User. Local time Tomorrow, 08:28 Joined Oct 30, 2008 Messages 1,257 Feb 1, 2020 #1 If a single field in a query contain the same thing for every record, is there an Access method for True or False Or is looking/comparing each one the way to go?
If a single field in a query contain the same thing for every record, is there an Access method for True or False Or is looking/comparing each one the way to go?
GinaWhipp AWF VIP Local time Today, 16:28 Joined Jun 21, 2011 Messages 5,899 Feb 1, 2020 #2 Not sure if this is what you are asking but you could make a second column and use... Code: Matches: If([MyOtherField]="YourText", True, False)
Not sure if this is what you are asking but you could make a second column and use... Code: Matches: If([MyOtherField]="YourText", True, False)
Cronk Registered User. Local time Tomorrow, 06:28 Joined Jul 4, 2013 Messages 2,799 Feb 1, 2020 #3 Or create a query, grouping on the field and counting the occurrence of each value ie select FieldName, count(FieldName) from TableName group by FieldName
Or create a query, grouping on the field and counting the occurrence of each value ie select FieldName, count(FieldName) from TableName group by FieldName
K kirkm Registered User. Local time Tomorrow, 08:28 Joined Oct 30, 2008 Messages 1,257 Feb 1, 2020 #4 Thank you Gina and Cronk. I used the Count query and is working nicely
