Field Name: 13-01 (Data Type: Currency)
Field Name: 13-02 (Data Type: Currency)
Field Name: 13-03 (Data Type: Currency)
Field Name: Desc (Data Type: Text)
My query
SELECT tbl_history.Desc, tbl_history.[13-01], tbl_history.[13-02]
FROM tbl_history
I am looking for a way to change query to
SELECT tbl_history.Decs, tbl_history.[13-02], tbl_history.[13-03]
in the next month. Currently, I do it manually. Having been do this for quite sometime but am trying to learn more from you.
Regards, jay
--- In AccessDevelopers@yahoogroups.com, Duane Hookom wrote:
>
> 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@...
> >
> > 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 (3) |
Please zip all files prior to uploading to Files section.
Tidak ada komentar:
Posting Komentar