Creating a field with a specific value In a SQL query

[tbonehwd]

Is it possible to add a non-existant field and give it a value. I want to Select a field in a query that doesn't exist and make the value of that field TEST (for example), the reason for this is to later use the value to link several queries together. If it can be done how do you do it?

Thanks,

Terry

 

[Golom]

Select "TEST" As FakeField, ...

 

[PHV]

Or, in the query grid:
FakeField: 'TEST'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[tbonehwd]

Thank you both it worked perfect!