Date month in report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that needs to show the MONTH and it’s specific DOLLAR value
horizontally. I have showing vertically, not a problem, but the VP wants it
horizontally, and wants to show every month even if there is a null value.
The report needs to read as :

Jan Feb Mar Apr May June etc….
Bus Area 1 $1 $3 $4 $6
Bus Area 2 $2 $6
Bus Area 3 $1 $3

The query is giving the data, but it’s not distinguishing the $$ value with
it's specific month. I’m getting this:

Jan Jan Jan Jan Jan Jan
Bus Area 1 $1 $1
Bus Area 1 $3 $3
Bus Area 1 $4 $4

Bus Area 2 $2 $2
Bus Area 2 $6 $6

Bus Area 3 $1 $1
Bus Area 3 $3 $3

I can’t seem to get the totals to associate with the month, nor get the
months to be in order across the top. Please help.
 
Cyndi said:
I have a report that needs to show the MONTH and it's specific DOLLAR
value horizontally. I have showing vertically, not a problem, but
the VP wants it horizontally, and wants to show every month even if
there is a null value. The report needs to read as :

Jan Feb Mar Apr May June etc..
Bus Area 1 $1 $3 $4 $6
Bus Area 2 $2 $6
Bus Area 3 $1 $3

The query is giving the data, but it's not distinguishing the $$
value with it's specific month. I'm getting this:

Jan Jan Jan Jan Jan Jan
Bus Area 1 $1 $1
Bus Area 1 $3 $3
Bus Area 1 $4 $4

Bus Area 2 $2 $2
Bus Area 2 $6 $6

Bus Area 3 $1 $1
Bus Area 3 $3 $3

I can't seem to get the totals to associate with the month, nor get
the months to be in order across the top. Please help.
Click to expand...

Use a crossing field query
There' the wizard for that


--
_ _
Ciao
MAssimiliano Amendola www.accessgroup.it
Cisa1 - I° Conferenza Italiana per Sviluppatori Access Arezzo 4+5
Giugno 2005 Sono aperte le iscrizioni Info: www.donkarl.com/it
 
Back
Top