Please help me, I'm out of my depth!!

[Lee]

Hi folks,
I do hope you can help as I don't know what to do about
the following.
I've done a database and was asked to provide exports of
data in a specified format for our Accounts system
to 'pick up' to enable invoicing to take place. I've
done this and am happy with this BUT, I've now been asked
if I can provide the exports (.dat) split into
monthly 'chunks' so instead of producing one file with
all records, they want a number of smaller files that
contain the requests for a particular month. This is
where I've come unstuck as I don't know how to instruct
Access to run the export query to produce a number of
files. My initial thought is that if I use a parameter
query I can get the user to input a month prior to each
export until they've gone through all the months but this
is pretty clumsy! I'm pretty new to Access and have done
this database as a favour to another department so I'm
certainly no expert.
Should I be writing a Do Loop or something similar? I've
never done this before so need some guidance!!!
Any help you can give would be REALLY appreciated.
Kind regards

Lee

 

[Mike Painter]

Hi folks,
I do hope you can help as I don't know what to do about
the following.
I've done a database and was asked to provide exports of
data in a specified format for our Accounts system
to 'pick up' to enable invoicing to take place. I've
done this and am happy with this BUT, I've now been asked
if I can provide the exports (.dat) split into
monthly 'chunks' so instead of producing one file with
all records, they want a number of smaller files that
contain the requests for a particular month. This is
where I've come unstuck as I don't know how to instruct
Access to run the export query to produce a number of
files. My initial thought is that if I use a parameter
query I can get the user to input a month prior to each
export until they've gone through all the months but this
is pretty clumsy! I'm pretty new to Access and have done
this database as a favour to another department so I'm
certainly no expert.
Should I be writing a Do Loop or something similar? I've
never done this before so need some guidance!!!
Any help you can give would be REALLY appreciated.
Kind regards

Lee

The easy way would be to create the query, add a field that formats the date
to just the month (number if you are as lazy as I am.) Put 1 in the criteria
for the month field.
Save it as January.
Cut and paste 11 more naming them and changing the criteria to 2, 3 4, etc.

A menu could be built that ran each month, all months, a quarter etc.

 

[Lee]

Yep, that sounds a good idea to me!!! Thanks for the
suggestion Mike - a much easier work-round.
Kind Regards,

Lee
___________________