Re: Perplexing Query Results
- From: That Crazy Hockey Dood <ThatCrazyHockeyDood@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 17 Apr 2009 08:29:01 -0700
Stefan..
Thank you sir. That is what I was doing wrong and suspected that the lack
of a relationship between fields was an issue. Funny thing though.. Adding
a relationship between the Yr field did not work. It took the addition of
the Mth field to make this work correctly. Any additional thoughts/insight
on why that may be the case?
Thanks,
Jim
--
If it works then you are doing something right!!
"Stefan Hoffmann" wrote:
hi,.
That Crazy Hockey Dood wrote:
FROM [Admin Activity_tbl], [Call Center Activity_tbl], CCOPS_tbl, [PubYou have a full join in your query without further restrictions in the
Care_tbl], tblPayroll
WHERE ((([Admin Activity_tbl].Yr)=[Forms]![Monthly CPT]![Yr]) AND (([Call
Center Activity_tbl].Yr)=[Forms]![Monthly CPT]![Yr]) AND
((CCOPS_tbl.Yr)=[Forms]![Monthly CPT]![Yr]) AND (([Pub
Care_tbl].Yr)=[Forms]![Monthly CPT]![Yr]) AND
((tblPayroll.Yr)=[Forms]![Monthly CPT]![Yr]));
This tells me that I have something wrong with the first query. I guess
that I could use separate queries if need be but that doesn't seem efficient
to me. Help.
WHERE clause.
1. Create a new query, switch to the design view.
2. Add your tables.
3. Build the relationships between these tables.
4. Activate the grouping and enter your Sum() formula.
The relation should be at least between the year fields.
mfG
--> stefan <--
- References:
- Perplexing Query Results
- From: That Crazy Hockey Dood
- Re: Perplexing Query Results
- From: Stefan Hoffmann
- Perplexing Query Results
- Prev by Date: How to write a query that add 1 working day to the date
- Next by Date: Re: How to write a query that add 1 working day to the date
- Previous by thread: Re: Perplexing Query Results
- Next by thread: Re: Perplexing Query Results
- Index(es):
Relevant Pages
|
