AutoNumber ID displays

S

Sharon

I have a database for expenses. I have created a union query that pulls
together all of the different types of report IDs. Expense Report, Travel
Expense Report, Purchase Order Report. The problem is that in the query the
Autonumber is shown instead of the Report Name. How can I make the Report
Number display for the ENTIRE database.

For example

PurchaseOrderID: 1
PurchaseOrderNumber: PUR000100

ExpenseReportID: 1
ExpenseReportNumber: EXP000100

TravelExpenseReportID: 1
TravelExpenseReportNumber: TEX000100
 
S

Sharkbyte

Sharon:

Can you provide a little more information?

What is the structure of the three tables?
What columns are you selecting with your query?

Sharkbyte
 
S

Sharon

The first paragraph "qrytblReceipt" is the query information and the other
three are for each of the tables.

Thanks.


qrytblReceipt
«ReceiptID», «SupplierID», «ReportType», «ReceiptNum», «ReceiptDate»,
«MethodofPaymentID», «ExpenseReportID», «TravelExpenseReportID»,
«MasterCardID», «ReimbursementCheckID», «PurchaseOrderID»

tblReceipt
«ReceiptID», «SupplierID», «ReportType», «ReceiptNum», «ReceiptDate»,
«MethodofPaymentID», «ExpenseReportID», «TravelExpenseReportID»,
«MasterCardID», «ReimbursementCheckID», «ReceiptAmount»

tblTravelExpenseReport
«TravelExpenseReportID», «TravelExpenseReportNumber», «TripID»,
«MealCategory», ReceiptID, tblExpenseReport

tblExpenseReport
«ExpenseReportID», «ExpenseReportNumber», «ExpenseReportDate», «CategoryID»,
«MasterCardID», «ReceiptID»
 
Top