Count Field in a different query

[sam.eade]

Hi all,



Just to give you a bit of background, I'm trying to export three queries (a header, body and a footer) into three separate text files.

The Header contains generic information with a daily reference, the Body contains details of all items placed and the Footer shows how many items have been placed that day.


The footer query needs to have a field that counts the amount of records that are in the body query (on a daily basis). i.e. the footer would read "There have been " & [RecordCount].[Export.Body] & " items placed today"


I just can't figure it out from the Query Design. Does any one have any advice or need more information in order to understand the question?

Many Thanks

Sam

[ItsMe]

Using the filesystemobject library and enumerating lines of text is probably the solution.
https://www.accessforums.net/import-...tml#post225478

[pbaldy]

Try

DCount("*", "QueryName")

[sam.eade]

Try

DCount("*", "QueryName")

Thankyou pbaldy

[pbaldy]

Happy to help!

[ItsMe]

I totally missed the point on that one...