Re: Counting 3 different fields seperately on a report
- From: SLKoelker <SLKoelker@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 30 Mar 2007 11:08:02 -0700
Thank you so much for trying to help me, but I can't seem to get it to work.
I created the 'totals query' and put in the criteria Like "X" but when I go
to creat a report with my material query and my totals query (using wizard) I
get an error message that says: 'You've chosen fields from record sources
which the wizard can't connect. You may have chosen fields from a table and a
query based on that table, If so try choosing fields from only the table or
query.'
However, I did not use a table and a query I used fields from two seperate
query's based off the table. Please help.
"Jeff C" wrote:
Open the query builder, place the linked table in the query, insert one of.
the fields you wish to count the X's.
click on the button with the summation sign which makes your select query a
totals query.
In the criteria for the field you inserted place: Like "X"
for the summation select Count
--
Jeff C
Live Well .. Be Happy In All You Do
"SLKoelker" wrote:
My database is linked to a spreadsheet in excel (not sure if that is why I
can't get it to work). The three fields are text fields in which I insert an
'X'. These fields are mutually exclusive. If the material was rejected
initially the 'X' is in the rejected column. When I re-submit the material
the 'X' is moved to the pending column. And if it passes the second test the
'X' moves to the accept column. Does this help clarify? Please help.
"Jeff Boyce" wrote:
If you are using a query to get a total, and it gives you a parameter
prompt, often that's Access' way of reminding you that spelling counts!
Access asks you for a value (via a parameter prompt) when it can't find the
object you've named.
Your three fields, are they text fields, into which you have inserted the
letter "X"? Are they True/False fields, that store a "0" and a "-1" (for
Access data), but can be made to display a checkbox, or ...?
How you total up the columns depends on what the columns hold ... you might
need to use "Count" instead of "Sum"!
Also, from your description, it sounds like the three fields are actually
mutually exclusive (i.e., a record can only ever be only one of the three).
If that's the case, then your table is designed more like a spreadsheet than
a relational database table.
If this is true, you could use a single field and store the status
(accepted, rejected, pending) in that field.
Regards
Jeff Boyce
Microsoft Office/Access MVP
"SLKoelker" <SLKoelker@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C7F9AC13-AEF7-4026-8412-B14A19E39880@xxxxxxxxxxxxxxxx
Every equation I have tried (that I found on this website) has given me a
'parameter' prompt. What I need is very simple. There are 3 fields,
accepted,
rejected, and pending. I want to count the "X's" in each column to show
totals for each column at the end of the report. can anyone help??
- Follow-Ups:
- References:
- Re: Counting 3 different fields seperately on a report
- From: Jeff Boyce
- Re: Counting 3 different fields seperately on a report
- Prev by Date: Re: Grouping Problem
- Next by Date: Re: reporting excel vs access
- Previous by thread: Re: Counting 3 different fields seperately on a report
- Next by thread: Re: Counting 3 different fields seperately on a report
- Index(es):
Relevant Pages
|
