L
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
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