Transfer text with count

[Senthil]

Can we do a transfer text and have the count of data (I have only 1 field in
the table) in the file. Like we do this to get the date along with the file
name

="C:\YourFolder\FileName_" & Format(Date(),"mmddyyyy") & ".txt"

 

[Jeff Boyce]

I'm not understanding what you mean by "the count of data".

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Senthil]

Count of data meaning.....I have a table with 1 field and it has 300 records.
I want the count of records.

 

[Jeff Boyce]

One way to "count the records" would be to use a Totals query and the
"Count" aggregation.

Another would be to use the DCount() function.

Check Access HELP for help on these...

Regards

Jeff Boyce
Microsoft Office/Access MVP