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 3 1642
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... 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
"benton " <u11025@uwe> wrote in message news:57baebacf0 5d8@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.c om 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
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... 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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Classified |
last post by:
Hey There,
Have a problem, hopefully someone out here can lend me a hand.
Working on an appointment databases, haven't used VBA in ages and I am find
a lot of rust everywhere.
What I'm trying to do, search the databases using Dcount for any records
that match the Date and time of the appointment prior to it being added to
the database,...
|
by: jdph40 |
last post by:
I posted this problem previously and received excellent help from
Wayne Morgan. However, I still have an unanswered question. My form
(frmVacationWeeks) is opened from the OnClick event of a button on
another form (frmEmpList) which has a list box that contains the names
of all employees. When a name is selected in the list box and the...
|
by: Megan |
last post by:
Hi Everybody-
I've been reading some of the posts about DCOUNT, and I haven't yet
found an answer; so, I'm posting this question.
I have a report that I'm trying to use DCOUNT on to compute the
percentages of each group. The groups are based on sports. For
instance, football, soccer, baseball, basketball. I have a table of
people that...
|
by: Mike Conklin |
last post by:
This one really has me going. Probably something silly. I'm using
dcount for a report to determine the number of different types of
tests proctored in a semester.
My report is based on a parameter query which is the recordsource for
the report. The parameter is <=. The query returns the
correct amounts upto the date entered (no need for...
|
by: SheldonMopes |
last post by:
I'm having difficulty with the DCount function, not getting the
results that I want.
Field1A and Field2A are fields in TableA matching Field1B and Field2B
in TableB
Using a calculated control in a subform bound to TableB, Field1B and
Field2B are on the form. (Control names are txtField1B and txtField2B)
| |
by: jstaggs39 |
last post by:
I want to create a Dcount and an If...Then...Else statement to count
the number of records in a table based on the date that is entered to
run the form. The If....Else statment comes in because if the amount of
records for a particular date is positive, i want the form to stop
running, if there are no records that contain the date in question,...
|
by: Kaspa |
last post by:
Hello I am trying to create dcount field but is not working I have
tried every way possible and I can't get it to work. here is my code:
=Dcount("","qryTotalscratched"," in (6,7,8,9) and
between #01/01/2001# and " & )
I also tried:
|
by: ringer |
last post by:
I am trying to add a functionality into a db I use for my checkbook that will help me plan for and save money for future large expenses. Into a table called tblFutureTransactions I want to enter records for upcoming large expenses, the dollar amount needed, the date the money is needed, and the date I want to start saving. Then I want the db to...
|
by: 6afraidbecause789 |
last post by:
I was able to glean syntax online for a DCount on a form that counts
the number of 'misbehavior' incidents for students for the current
day:
=DCount("StudentID","Incidents","StudentID=" & Forms!
frmIncidentSummary!StudentID & " and
datediff(""d"",IncidentDateTime,date())=0").
However, there is another field, named IntType, that...
|
by: Cron |
last post by:
Hi I'm trying to Dcount *unique* records by comparing a date/time
field. I say *unique* because the field contains a date/time but I
need to ignore the timestamp and work off the date only.
I think the code below should work to count unique values in a normal
text field but the date/time is causing a lot of problems because it's
reading the...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
| |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |