By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,504 Members | 1,110 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,504 IT Pros & Developers. It's quick & easy.

dCOUNT DATE

P: n/a
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.com
http://www.accessmonster.com/Uwe/For...ccess/200511/1
Nov 23 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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:57baebacf05d8@uwe...
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.com
http://www.accessmonster.com/Uwe/For...ccess/200511/1

Nov 23 '05 #2

P: n/a

"benton " <u11025@uwe> wrote in message news:57baebacf05d8@uwe...
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.com
http://www.accessmonster.com/Uwe/For...ccess/200511/1

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

Nov 23 '05 #3

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

"benton " <u11025@uwe> wrote in message news:57baebacf05d8@uwe...
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.com
http://www.accessmonster.com/Uwe/For...ccess/200511/1

Nov 23 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.