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