Transfer text with count

  • Thread starter Thread starter Senthil
  • Start date Start date
S

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"
 
I'm not understanding what you mean by "the count of data".

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Count of data meaning.....I have a table with 1 field and it has 300 records.
I want the count of records.
 
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
 
Back
Top