|
|
| Author |
Message |
Dazz
Guest
|
 Posted: Thu Apr 27, 2006 1:38 pm Post subject: Access Report |
 |
|
Hi,
I am trying to build a report from a query.
In it i have Customer, Product Code and a Quantity. I would only like to
show products that have a Quantity value Greater than 100 and Lower than -100
by customer.
This i can do in the query OK.
My problem is that i need to have a grand total of all the products, by
customer in the report and not just those values selected in the query above.
Is this possible?
Thanks in advance
Dazz |
|
| Back to top |
|
 |
|
|
Davy
GURU
Joined: 30 Apr 2005
Posts: 1862
Location: Nr Manchester. UK
|
| Posted: Thu Apr 27, 2006 2:57 pm Post subject: Re: Access Report |
|
|
Use Excel in MS Office there you can create a spreadsheet, formatting the columns and rows as required will allow you you add the totals and create Pie charts and queries etc.
Davy |
|
| Back to top |
|
|
DL
Guest
|
| Posted: Thu Apr 27, 2006 5:39 pm Post subject: Re: Access Report |
|
|
I think you need two seperate queries then create the report, or possibly a
crosstab query for the report source.
Allthough I'm a little perplexed by, quantity >100 and <100
"Dazz" <Dazz@discussions.microsoft.com> wrote in message
news:D7E43831-B908-4B0E-8461-AACE3C2BA3C6@microsoft.com...
| Quote: | Hi,
I am trying to build a report from a query.
In it i have Customer, Product Code and a Quantity. I would only like to
show products that have a Quantity value Greater than 100 and Lower
than -100
by customer.
This i can do in the query OK.
My problem is that i need to have a grand total of all the products, by
customer in the report and not just those values selected in the query
above.
Is this possible?
Thanks in advance
Dazz |
|
|
| Back to top |
|
|
DL
Guest
|
| Posted: Mon Jun 04, 2007 3:13 am Post subject: Re: Access Report |
|
|
Are these name fields duplicates in both tables?
"Derek" <Derek@discussions.microsoft.com> wrote in message
news:C0400073-7D15-4750-8E81-280B8331B770@microsoft.com...
| Quote: | I have an Access report that pulls from 2 different tables. the main
table I
have a first and last name field, and the 2nd table I also have a first
and
last name table. I can concantenate from the first table and combine the
first and last name fields into one text box on the report, BUT, when I
try
to do the same for the second table it won't work. I have even tried
using a
query, and while the query works, when I put it on the report it can't
find
any information from the query. Please help. |
|
|
| Back to top |
|
|
|
Watched Topics
Search
Register
Log in to check your private messages
Profile
Log in
Memberlist
Usergroups