Recent content by matthej

To be honest, I hadn't considered using the month numbers or accounting for the year. I guess I'll just make that column a full date to make it more useful, as you metioned. Woah...lots to learn about this stuff. thanks again for your help.

Thanks for the insight. By "normalizing", I'm assuming you mean to change the data into a the following sort of table: Machine Month GB X Jan 3 X Feb 2 Y Jan 5 etc.... and then do a select query on that? is that what you mean? thanks, again.

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

HAH! It worked! I would never have thought to do that...Thanks so much. You have saved me hours of research! thanks, Matt

yes. I have form/switchboard open (called Test Switch), the base query open (and this adjusts as I change the criteria as it should), but the crosstab query won't open...I get the following error: "The Microsoft Jet database engine does not recognize '[Forms]![Test Switch]![Combo10]' as a valid...

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