crosstab issue

[motleyjew]

I need some help with a crosstab query. I’m not to experienced using it and I’m pretty sure it’s what I need to use. Here is a quick breakdown on the key fields in the tables.

Table: TBL_BOM
ProjectID
ResType
Res_subcat
UnitPrice
Monthneeded

Table:TBL_Budget2008
projectid
Totaltax ie $1,026
Freight ie $100

I created a crosstab query and it looks exactly how I need it to. I've included a word doc with the query examples.


All of the above data is from the TBL_BOM table only. I need to add the freight and the total tax to this query from the TBL_Budget2008 table. The common field is the project id. There is only one project id each in the budget table. I need to take the total tax and freight for each project and have it add into only one of the months, or to be distributed between the months. I cannot put data in an empty fields. It must go into either 1 field with data or into be distributed into the populated fields for its shared projected.

 

[motleyjew]

Disregard. I figured it out with doing multiple select queries. My brain hurts. I would give more details, but I don't even know how to explain it.