Jay,
Is there any way you could share your table and field structure?
It should be a simple matter of pulling the current month from Date() and using it to automate. It all depends on what you have and what exactly you want.
Duane Hookom MVP
MS Access
________________________________
> From: jaykay@sh163.net
>
> I created a table to store the monthly data. Query the current and
> previous and calculate the difference. Generate a report showing
> current, previous and the difference from this query. The problem here
> is every month I have to manually change the query, i.e. changing the
> selection of the current and previous month data.
>
> Question: Is there a way to do away with the manual set up, like select
> current and previous month data through a form, or any other methods?
>
> Any ideas will be much appreciated.
>
> Regards, jay
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Please zip all files prior to uploading to Files section.
Tidak ada komentar:
Posting Komentar