Search results

Hi, I have a particular table -- Store Product Quantity 4241 Perdue Fryers 1 4242 Perdue Fryers 2 4243 Perdue Fryers 6 4244 Perdue Fryers 3 4246 Perdue Fryers 2 4241 Perdue Breast 3 4242 Perdue Breast 1 4243 Perdue Breast 0 4244 Perdue Breast 6 4246 Perdue Breast 4 4241 Perdue...

Hi, Firstly, thank you all for the help you've offered me so far. That said: I'd like to essentially run an UPDATE on every record in the table, altering each with different data. For instance, I have one table (Table1) with Field1, Field2, and Field3. On the table I'm updating (Table2)...

Hi. I'm sure this is very simple, but I certainly haven't been able to figure it out. I have two tables: PRODUCTS Name (irrelevant fields) VENDORS Name (irrelevant fields) I'd like to create a query that will produce a row for every possible combination. That is, I'd like the returned set...

Hi, I apologize if this is a redux. I have two tables, Products and Vendors. I would like to create a third table with a field for each vendor so I can specify price per product per vendor, similar to the example below. Is there a way to have a table draw its fields dynamically from an...