Access query problem - Help

[Phillip MItchell]

I posted this yesterday, but it doesn't appear to have gone through.

Trying again.

Hi all,
I wonder if someone could help me tell me what I need to put in my query to
do the following.

I have a report with gets it's information from a query, well related
queries actually.

The report lists every job down for a 12 month period, a job number and job
title, the number of groups done for each job ( were a market Research
recruiting company for focus groups) The problem I have instead of I guess
grouping all the groups as one, it will show the job number and job title
again and again depending on how many groups were done under each job
number.

The format is this.
Job # Title No of Groups . Date rang of groups, Total No of groups per
job, Total Number of recruiters who worked on the job. Job Location.

This is what report currently shows.
2510 PROJECT NON & HON (A 17/05/2007 14/05/2007 2 1 Melbourne
2510 PROJECT NON & HON (A 17/05/2007 14/05/2007 2 1 Melbourne
2510 PROJECT NON & HON (A 17/05/2007 14/05/2007 2 1 Melbourne
2510 PROJECT NON & HON (A 17/05/2007 14/05/2007 2 1 Melbourne
2519 GEN Y (AMEND) 1/05/2007 14/05/2007 1 1
Melbourne
2519 GEN Y (AMEND) 1/05/2007 14/05/2007 2 1
Melbourne

Where as I want it to show this

2510 PROJECT NON & HON (A 17/05/2007 14/05/2007 4 8 Melbourne
2519 GEN Y (AMEND) 1/05/2007 14/05/2007 2 6
Melbourne

Does this make sense?

The problem is with one of the queries, any suggestions?

Thanks in advance

Phil

 

[John Spencer]

It might help if you could tell us the how the first 4 lines are
supposed to return the 1st line of what you want.

How do four twos end up as 4 and four ones up as 8?

And for the next set
How does two and one end up as 2 and two ones end up as 6?

I cannot figure out the logic from what you have posted, I can guess
that you are attempting to get a unique count groups per job and
recruiters per job. That doesn't work though given the example you posted.

Also your posted format does not seem to conform to your data.

Try again. I am going to be offline until tomorrow, so perhaps someone
else will pick up the thread when you post your response.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

 

[Phillip MItchell]

Hi John

Yes sorry I should of posted more details

Without actually attaching the queries snap shots, I'll see how else I can
post info,

Thanks

Phil

 

[John Spencer]

As a start

Open the query in design view
Select View: SQL from the menu
Copy the SQL statement and post it here.

Then describe what results you want and how those results should be
calculated (as if you were doing it with a pencil and paper).

With that information it is probable that someone can help you develop a
solution.
'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

 

[Phillip Mitchell]

Hi John, yes that would be easier for people to understand what I am on
about, short of posting a pdf print off or a snapshot of the query, which
one cannot do in these groups as they are not a binarie group

Thanks I'll do it when I get some fre time, work is a bit flat out
Phil