Access 97 Query Problem - TechRepublic
General discussion
October 9, 2002 at 02:55 AM
mra2

Access 97 Query Problem

by mra2 . Updated 23 years, 9 months ago

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

This discussion is locked

All Comments