Show Source of Data in Query without adding another field?

[dichotomous]

Hello people.

Can someone tell me how I show the source of the data in a query without adding another field in the table.?

I want to pick up expiry dates from a number of tables in a series of expiry queries.

E.G from plant register - expiry of registrations etc
from training register - expiry of training received
etc

Then I want to join them all in a union - which I've done, but you can't tell where the data has come from.

 

[Insane_ai]

You would have to add the additional field as you build each of the source queries that are used in the Union or make a calculated field with all of them before the union.

it would look something like this:
Expr1:"my source - " & [field]

Then join the three in a union.

 

[June7]

This is just an expression to create a field in query.

SELECT "plant" AS Category, Expiry FROM PlantRegister
UNION SELECT "training", Expiry FROM TrainingRegister;

 

[dichotomous]

You would have to add the additional field as you build each of the source queries that are used in the Union or make a calculated field with all of them before the union.

it would look something like this:
Expr1:"my source - " & [field]

Then join the three in a union.

Thank you - that helped.

 

[dichotomous]

This is just an expression to create a field in query.

SELECT "plant" AS Category, Expiry FROM PlantRegister
UNION SELECT "training", Expiry FROM TrainingRegister;

Thank you - that Solved.