G
Guest
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
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