how to create cascading query at run time

[dogdays]

I have a table tblFiscalGifts which contains an ID number, the amount of the gift and the source code for the gift. At run time a user may select n number of source codes from a listbox to select for a report. I would like to generate a series of queries or SELECT statements which would result in a record set of all ID numbers that gave to all the selected source codes e.g.
select the first code, then select the next code using the results of the previous select until the final set.

tia Jack

 

[dogdays]

Kreszch68:
Thank you. I made one change set COUNT (ID) to >= to handle the issue of a patron donating more than once to the same fund raiser.
I do have one question- since I am the designer of the schema in question what did do that was wrong?
I am self taught in Access and would prefer not to make the same mistakes in the future.

tia Jack

 

[Kreszch68]

Jack, it's hard to tell how exactly you should set up you data as I don't have a complete picture of what you are doing.
But in general take in mind that you should always have a unique identifier for each record. This will make it so much easier to retrieve records.