Freight broker training cost39 comments
Que es trading de commodities
Is there a way to do this in Access? Sign up today x. Use a union query: I would like the results to be in the same table Do you mean query? Do you want them to be in the same row or separate rows? You might start with the original data and do a query on that. Experts, I want them on separate rows. The problem I am having now is I only want the using distinct in count in Access. That's what the union query does. Go back to the original table.
Experts, I am sorry for the confusion. My problem is not concatenating the totals into one table now. The problem I am having is counting unique values for the respective tables.
It is possible to have multiple records with the same key value. I want to count a person only once. How would I get distinct values in an access query? You keep asking this, but yes, that's what the union query does. Unique values of what? For the Girls, try something like: We are flying blind here.
Sounds like you have a table of people and a table of transactions and you want to count by gender the number of people who have had a transaction. Then create a second query to count the records from the first one. If Gender isn't in the transaction table you will need to join to the persons table in one of the queries to pick it up.