Discussion Locked

Access 97 Query Problem

0 helpful

5 replies

by mra2 Oct 9, 2002 last reply Oct 10, 2002

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

My Database has Member Names (MemberName), Card Type (CardType) and Previous Gold Cards Taken (PrevGold).

I wrote Query # 1 which has the MemberName AND SHOWS ONLY those records where CardType = "Gold".
That Query works fine.

I then wrote Query # 2 (Source is Query # 1) which has MemberName, The Count of CardType, PrevGold and a column called SumGold.

SumGold is:
SumGold: [CountofCardType]+ [PrevGold}

Query # 2 pops up with a Parameter box asking for CountofCardType. I make NO ENTRY and just click the OK box. I then get the right answers.....

How do I stop the Query from bringing up this Parameter box?????????

I can Email a mini version of the mdb file if that would help you.....

abramowitza@coned.com

Thanks a Lot,
Alan

5 replies

Just Select (Expression) instead of (Group By) in the column called (SumGold) in the (Query # 2)you will succeed.
regards

Dear Abel,
Well, I don't quite understand why it works, but it WORKS GREAT!!! Thanks so much!

Alan

Dear Abel,

I don't undrstand why it works, but it works GREAT!!!

Thanks, Alan

This question was closed by the author

This question was closed by the author

This discussion is closed to new replies.