Search results

When I query a query and include fields from a table, the fields duplicate. I sorted this by selecting the join type as "only include rows where the joined fields from both tables are equal". I have two tables and two queries that I want to create a query about. The joins come via the field...

I am having trouble with the count feature. I am writing a cricket database and I need to count the number of times the words "Not Out" appear in a field (called HowOut). I have tried to put "Not Out" in to the criteria box and then created a calculated field to count that. This worked if the...