I need help on this dynamic report

  • Thread starter Thread starter SG
  • Start date Start date
S

SG

Hi,

I'm assigned a task to generate a dynamic report which shows the sales
number based on the month chosen.
The structure of the table 'Sales' is
account, name, $Jan-lastyr, $feb-lastyr, $mar-lastyr....., $Jan-thisyr,
$Feb-thisyr, $Mar-thisyr.....
I have a form "Form1" for user to be able to choose the month they are
looking at. If user chose month 'Jan' (always the month of current year), on
the report, I like my report to show from Jan Last year forward 12 month
sales which is up till this Jan by month.
For example:
acccount, name, Janly, febly,........Jan-thisyear
If user chose "March", the report will be like:
account, name, Marly, Aprly.......Mar-thisyear.

I have no clue how to make this report with heading and data changing
whenever the month changed.
I need a help on this.

thanks in advance,

Sarah
 
There is a sample report in the Developer solutions database (solutions.mdb)
packaged with access under "Using queries with Forms and reports./Create a
crosstan query for a report" that will give extensive details to accomplish
what you need,
 
Back
Top