Search results

jal, That is not a typo. Field [StoreA] on table tbl_MasterProductList contains the product names for store A. There are around 400 records and union takes about 3 seconds. I'm used to querys happening instantly. This is running on an Intel Quad core PC, so computer speed is not an issue...

The union looks a little like this; SELECT [ProductID] FROM [qry_StoreA] UNION SELECT [ProductID] FROM [qry_StoreB]; UNION SELECT [ProductID] FROM [qry_StoreC]; This list all the products from all the stores, as some products are not available at all stores. The qry_StoreA reads; The...

Hi Jal. I have a union query that I think is the bottleneck. Do these normally run slower?

Gemma, I forgot to ask. Were you suggesting that the table should include all stores or one table for each store? How would I do this in 2 queries?

At the moment, I have all the values saved in separate csv files for each store. Are you saying it would it be better then to save the values in one csv?

The "Small", "Medium" and "large" fields refer to the cost of the product at that size. E.g. Small Sized ProductA may cost $2 and a Medium Sized ProductA may cost $5 Yes, I have a table with a primary key (auto number) and a field with a master list of product names. Each subsequent field...

I'm usually not bad with queries, but this one is giving me a headache. It's producing results but takes a while to do it. It's like a cost comparison query, the following is an example: I have the following stores: Store A Store B Store C And each store carries similar products...