Constant values in a query

[Martin Hopkins]

Hi,

I have a query that is exported as an excel spreadsheet with details of
persons gonig away for more than 4 days. However, some of the fields that
are required in the excel sheet, which is sent to another department, have
to be manually updated after the export as they are not in the database
table structure.

Instead of updating the table structure, as the data is always the same eg
British, Male, Transport, Yes,
can I put into the query these fixed values that will always be exported
with the query without them being ib the table structure?

Any help greatly appreciated.

Martin Hopkins

 

[Lynn Trapp]

Yes, you can add a constant to a query:

Select Field1, Field2, Field3, "MyConstant"
From MyTable;

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[John Spencer]

Yes, you can

In the query grid, just add calculated columns as follows
Field: Nation:"British"

Field: Gender: "Male"


If you are using the SQL text
SELECT "British" as Nation, "Male" as Gender, ...