Export an automatic count field

[Garry]

Hi, is it posible to export through a query a count field

Say I have 10 names and willexport to an excell file in name order

Andy, Bill . . . . . . . .Peter etc

Can I automatically create the count field

So Name - Bill, Account - 2 for example

Cheers

 

[John W. Vinson]

Hi, is it posible to export through a query a count field

Say I have 10 names and willexport to an excell file in name order

Andy, Bill . . . . . . . .Peter etc

Can I automatically create the count field

So Name - Bill, Account - 2 for example

Cheers

Yes; create a Totals query that does the count and export that Query.

Bear in mind that we can only see what you type here; without any information
about your table structures or what it is you're counting it's more than a bit
difficult to give specific advice.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[Garry]

Hi John, you are correct, I did not explain very well

I might have 20k address records for printing and I would like to number
them from 1 - 20k and print in that order

If any do not print correctly I can just look up the number rather than the
name
and print that record, much quicker

Garry

 

[John W. Vinson]

Hi John, you are correct, I did not explain very well

I might have 20k address records for printing and I would like to number
them from 1 - 20k and print in that order

If any do not print correctly I can just look up the number rather than the
name
and print that record, much quicker

You've described what you want to accomplish more clearly now. But you have
not mentioned your table structure.

Where are these addresses stored? How is the sequential order defined? Where
do you want to store this sequential number? Why would it be any easier to
find a record by looking up a number rather than looking up the address?
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[Garry]

Hi John, thank's for your time

The data is stored in access 2007 > Newsletter

I would like to export, sorted in order - Company > DepartmentCode > Surname

FirstName

I need to mail merge with body copy so thought exporting as a csv file too
MS Word would be the way to go

I dont mind where the number is stored if exporting is not the way please
advise

Garry

 

[John W. Vinson]

Hi John, thank's for your time

The data is stored in access 2007 > Newsletter

I would like to export, sorted in order - Company > DepartmentCode > Surname

I need to mail merge with body copy so thought exporting as a csv file too
MS Word would be the way to go

I dont mind where the number is stored if exporting is not the way please
advise

Garry

If you don't need to store it at all, just use a Report with a textbox with a
Control Source of 1 (just the number one) and set its Running Sum property to
Over All.

Alternatively you may need to use VBA code opening a Recordset and using
automation to feed the data to Word directly, bypassing the export file.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[Garry]

Thank's that works just fine, Garry

If you don't need to store it at all, just use a Report with a textbox
with a
Control Source of 1 (just the number one) and set its Running Sum property
to
Over All.

Alternatively you may need to use VBA code opening a Recordset and using
automation to feed the data to Word directly, bypassing the export file.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com