Extracting information from access to excel

[Guest]

I have a database that contains a series of numbers (lottery)... i would like
to extract the number of times a certain 3-4-5-6 number combination appears,
and have that number transferred to an excel worksheet that contains those
3-4-5-6 number combinations, is this possible? I have the database setup by
date, and within each date i have arrananged each 6 digit combination from
low to high. Any help would be appreciated

 

[strive4peace]

Make a new query based on the table/query with your combinations

from the menu --> View, totals -- OR click the 'Sigma' (sideways 'M')icon

on the grid -->

field --> Combination_fieldname*
Totals --> Group By

field --> Num: PrimaryKeyField
Totals --> Count

from the menu -- File, Save As --> CombinationCounts

from the Query menubar:
File, Export...
OR
from the database window, Right-click mouse on query just created and
choose --> Export...

create filename and change file type to Excel


*where
Combination_fieldname
is the fieldname for the combination or a concatenation of the choices...

For instance:
Combination: [field1] & "-" & [field2] & "-" & [field3] & "-" & [field4]


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*