setting criteria to select information from records 1

[atray04]

I am having a problem with my current query. I have a query that looks at all of my records and if a value in a record is less than 3 show the whole record and generates them in a report.

My problem is that I would also like to have a report with only the values less than 3 within that report. I can not seem to selectively take out the values larger than 2 in each of my records. Does anyone else know how this might me done?

-Atray

 

[atray04]

Oops actually if I do it that way I run into the same problem with the criteria.

-ATray

 

[lespaul]

what do you mean?

Leslie

 

[atray04]

I that is in reference to the post right before your last one

 

[atray04]

No, you fixed my query question. I am just having trouble figuring out how to group it in my report. If you know the answer to that please let me know, but if not thank you for your help.

-ATray

 

[atray04]

lespaul, what I mean is that everything works great except that each record on my report lists just one item instead of grouping the items

example:
record 1:
Inspector: Joe Department: Food
Date: 4/20/04 Area: Stove
Score: 45

EquipmentA: 2

record 2:
Inspector: Joe Department: Food
Date: 4/20/04 Area: Stove
Score: 45

EquipmentB: 1

and so on.....

I would like my report to be more like this:
record 1:
Inspector: Joe Department: Food
Date: 4/20/04 Area: Stove
Score: 45

EquipmentA: 2
EquipmentB: 1
and so on....

Anyways that is what I meant and I am wandering if it is because my field on my report is pointing to item and not a specific item.

-ATray