Need help with a query please.

Last Post 06 Oct 2004 04:59 AM by Gazzoid. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Gazzoid
New Member
New Member

--
06 Oct 2004 04:59 AM
Hi, I have the following problem. I have two tables, one containing a timesheet header, i.e. timesheet number, name etc and the other containing 8 rows of rates for the header. I need to create a query that returns just one row containing the the header and each of the 8 rates for example

table 1
=====
Ts ID 2 Header

table 2
=====
Ts ID 2 Rate 1
Ts ID 2 Rate 2
Ts ID 2 Rate 3
Ts ID 2 Rate 4
Ts ID 2 Rate 5
Ts ID 2 Rate 6
Ts ID 2 Rate 7
Ts ID 2 Rate 8

would return

TS ID 2, Rate1, Rate 2, Rate 3,Rate 4,Rate 5,Rate 6,Rate 7, Rate 8

any help appreciated

Regards

Gary
You are not authorized to post a reply.

Acceptable Use Policy