Query Problem

[Paul]

Hi
I have a problem with a query which hopefully somebody may be able to sort?

I have 2 tables:
tblComputer
tblHardware

which contain the following:

tblComputer:
UserID Make Value
PH Dell £500.00
AB Acorn £200.00

tblHardware
UserID Type Value
PH Zip Drive £50.00
LB Camera £100.00

I need to create a report that shows the breakdown value for each User and
the total value:
PH Dell £500.00
PH Zip Drive £50.00
Sub Total £550.00

AB Acorn £200.00

LB Camera £100.00
TOTAL £850.00

Any ideas would be greatly appreciated....
Paul

 

[Bogdan Zamfir]

Hi,

You need to use a union query, then use it as a row source for a report.

Something like this:

select UserID, Make, value from tblComputer
union
select UserID, type , value from tblHardware

Then in the report, make a grouping report, and group on UserID.

If you have any more questions or need more details, you can contact me

Regards,
Bogdan Zamfir
_________________________________
Independent consultant