View Single Post
Old 03-18-2020, 12:22 PM
Maphisto's Sidekick's Avatar
Maphisto's Sidekick Maphisto's Sidekick is offline
Join Date: Nov 2001
Location: South Park Genetics Lab
College: Ardnox
Favorite beer: The kind with alcohol
Posts: 3,505

Originally Posted by 1695814 View Post
I have query that joins two tables, ReservesCurr & ReservesPrev, by Policy.
In each table is a field called "Reserve".

In my output, it is (automatically) labeling those "Reserve" & "Reserve1".

I'd rather have it be something more descriptive. Even ReservesCurr.Reserve & ReservesPrev.Reserve would be useful.

I don't know how to do that.
In the query design screen, you can assign new field names to the output of the query

In the top row, one cell might read "ReservesCurr: [ReservesCurr].[Reserve]", while another cell might read "ReservesPrev: [ReservesPrev].[Reserve]".

By doing that, you assign field name "ReservesCurr" to the "Reserves" value coming from table ReservesCurr, and you assign field name "ReservesPrev" to the other one.

This tactic also comes in handy when doing aggregate queries, and you don't want automatic field names like "SumOfReserves".
Reply With Quote
Page generated in 0.08465 seconds with 9 queries