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
select the first code, then select the next code using the results of the previous select until the final set.
tia Jack