Search results

Got it! TRANSFORM Avg(tblOrders.Quantity) AS AvgOfQuantity SELECT tblOrders.PID, tblOrders.Product, tblOrders.Vendor FROM tblOrders GROUP BY tblOrders.PID, tblOrders.Product, tblOrders.Vendor PIVOT tblOrders.StoreNumber;is what I was looking for. Thanks a lot, Jack.

Thanks, that looks like the right direction! I downloaded a few crosstab examples and am fiddling with them. If anyone has further advice I would greatly appreciate it. Thanks!

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...

Thank you very much, that's precisely what I needed. Thank you!

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)...

You're a beautiful human being.

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...

Ah, I get it. Okay, thank you very much.

On the subject of the "as you go" event for tabular forms: Say one wanted a textbox to be either enabled or disabled depending on the value of a field within a record. Is there a way to do this with a tabular form? A way to have a textbox enabled on one line for one record and disabled for...

How would I go about creating that table? Are there certain keywords I can look up in Access' help file?

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...