Thank you for the tips. I think, I know your approach to the problem. I will work on having year-month as a value in a field.
Regards, jay
--- In AccessDevelopers@yahoogroups.com, Duane Hookom wrote:
>
> Jay,
>
> As long as you are storing data (the year-month) as field names, you will always need to change your query design.Â
>
> Is there any way you can normalize your table structure so that the year-month is a value in a field and each currency value is in its own record?Â
>
> Duane Hookom MVP
> MS Access
>
> ________________________________
> > From: jaykay@...
> >
> > 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 (5) |
Please zip all files prior to uploading to Files section.
Tidak ada komentar:
Posting Komentar