Search results for query: *

I have the following table which captures a machine type and it’s available space in GB (This table is maintained in Excel….ultimately, I’d like to link Access to this table so that it captures any changes): Machine Jan Feb Mar Apr X 3 2 5 4 Y 5 7 8 3 I have a form that has three...

I have two queries that I'm trying to union. One pulls cost of inventory and the other pulls cost of goods sold. Each query also returns manufacturer. I want to union the two queries. Here’s what I have: SELECT [Prior Month].MFG, [Prior Month].Cost as [Cost of Goods Sold], '' as [PURCH...

Is there any way to add more than one value field to a crosstab query? Here’s what I have now: 2003 2004 CustomerXYZ $Sales $Sales Here’s what I want: 2003 2004 Sales Units Sales Units...

I have a basic query which feeds a crosstab query. In the base query I am able to make criteria selections either in the design view by "hard-coding" the selections or I can use a reference to a form to pick the criteria. The problem arises from the secon option. If I use a reference to a form...