One query record results as 2 separate lines??

  • Thread starter Thread starter GD
  • Start date Start date
G

GD

Is it possible to design a query to result in 2 separate lines per record?
Let's say I have the following as fields: invoice #, date, amount, approved
by, approval date. Can I get it to result in (including indentation, if
possible)?:

Record 1.invoice # Record 1.date Record 1.amount
Record 1.approved by Record 1.approval
date
Record 2.invoice # Record 2.date Record 2.amount
Record 2.approved by Record 2.approval
date
etc,etc,...

Or is a report necessary to accomplish this?

Thanks!!!!
 
UNTESTED --
SELECT [invoice #] AS [Invoice], [date] AS [Date / Approved By], [amount] AS
[Amount / Approved], 1 AS Record
FROM YourTable
UNION ALL SELECT Null, [approved by] AS [Date / Approved By], [approval] AS
[Amount / Approved], 2 AS Record
FROM YourTable
ORDER BY [invoice #];
 
Back
Top