show selected excel sheets

[markbrum]

Hi,

I'd like to run a report for a number of stores which includes a price list created in Excel. There are 50 different price lists but each store should only receive the lists applicable to them. I have a table with a record for each store and 50 fields, one for each price list, which is flagged. So I need to say print this price list for this record only if there is a Y in the corresponding field in the database. Can anyone show me how?

Thanks, Mark.

 

[Crowley16]

erm, hows about opening the table with a recordset, and the looping through all 50 records and printing all reports that have a "Y" specified...

--------------------
Procrastinate Now!

 

[markbrum]

sorry, i don't understand this answer. you seem to have sort of told me what i want to do but not how to do it? are you saying i need to make a report from each of my excel worksheets? i don't have 50 records i have thousands, each one has 50 fields, how can i loop though them?