dCOUNT DATE

[benton]

i got a a query that gives me the following results:

Month 2003 2004 2005
Aug03 11,000
Aug 04 3,200
Aug 05 700

What formula can I use to change the query into 1 line of August so I can
have all the values for 2003, 2004 and 2005 into one line

--
Message posted via AccessMonster.c om

http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200511/1

[Jeff]

Re: dCOUNT DATE

I assume you have a totals query that is counting records or summing some
values and grouping by month and year. Try just grouping on month.

Jeff Pritchard
_______________ _
Asken Research Pty. Ltd.
Access Database Developers

http://www.asken.com.au

"benton " <u11025@uwe> wrote in message news:57baebacf0 5d8@uwe...[color=blue]
>i got a a query that gives me the following results:
>
> Month 2003 2004 2005
> Aug03 11,000
> Aug 04 3,200
> Aug 05
> 700
>
> What formula can I use to change the query into 1 line of August so I can
> have all the values for 2003, 2004 and 2005 into one line
>
> --
> Message posted via AccessMonster.c om
> http://www.accessmonster.com/Uwe/For...ccess/200511/1[/color]

[Randy Harris]

Re: dCOUNT DATE


"benton " <u11025@uwe> wrote in message news:57baebacf0 5d8@uwe...[color=blue]
> i got a a query that gives me the following results:
>
> Month 2003 2004 2005
> Aug03 11,000
> Aug 04 3,200
> Aug 05[/color]
700[color=blue]
>
> What formula can I use to change the query into 1 line of August so I can
> have all the values for 2003, 2004 and 2005 into one line
>
> --
> Message posted via AccessMonster.c om
> http://www.accessmonster.com/Uwe/For...ccess/200511/1[/color]


It's a little tough to tell from the sample data posted, but it looks as
though "Month" might be a text field that contains both month and year
data - "Aug 04", "Aug 05", etc. If that's the case, that is not properly
normalized. That's the reason that it is causing a problem with reporting.
A field should contain a date, a month, a year, etc, but not more than one.

To get around the problem, you could use something like:

Group By Left([MyMonth],3)

That should put each month on its own row in the output.

HTH,
Randy

[Ed Robichaud]

Re: dCOUNT DATE

Change your X-tab query to a Select one to get the result you seek.
-Ed



"benton " <u11025@uwe> wrote in message news:57baebacf0 5d8@uwe...[color=blue]
>i got a a query that gives me the following results:
>
> Month 2003 2004 2005
> Aug03 11,000
> Aug 04 3,200
> Aug 05
> 700
>
> What formula can I use to change the query into 1 line of August so I can
> have all the values for 2003, 2004 and 2005 into one line
>
> --
> Message posted via AccessMonster.c om
> http://www.accessmonster.com/Uwe/For...ccess/200511/1[/color]