count record in query

[mikichi]

hi everybody,
i try to count records in a query but without lose the details(the data fields).
i success to do it with 2 different queries(1 to details and 1 to count records in details query)
how i uniting them to one query?


thanks a lot,
miki

[JoeM]

Well, you could try joining the two queries in a Union Query, but that typically only works if the two queries are of the same structure (same number of fields and data types for each field). You may be able to "pad" your count queries with blank fields to get that to work.

But the real question is why are you trying to combine the records and totals in the same query? Usually something like that is more commonly done on Reports and Forms, and that isn't too hard to do there (especially with the use of Subreports and Subforms).

Note that you can also use the DCOUNT function within your query to return the record count from a table or query. Just note that the count would appear once on every row (record).