query with sub queries

[jv2]

Hello...

Got a bit of problem creating this query which uses another query.
I have a query which takes parameters from form (month,year) which then lists all new stock in that month... then I have a crosstab query which sums new stock deliveries for each item within that month...
Then I have the main query which takes data from other tables to give me all the details per month for all stock items... such as stock take figures etc... to do my calcultaion I need to include the crosstab query in this query so that it displays how many items have been added to the stock.
But when I try to add this crosstab query and run the main query it just says "can't evaluate expression"...
any ideas where Im going wrong? or is there a better way to do it?

Thanks for your help!!

 

[jv2]

found a way round it

not using the sub query now... just the table... which then returns multiple record for one item if more than one new delivery... then in the report I grouped by item and the put the new stock in the detail (hidden) and used the sum in the calculations...