Values in a query ready for export to Excel

[Martin Hopkins]

Could anyone help please.

I have a query that exports data to an Excel spreadsheet ready fro onward
transmission to another department.

However the spreadsheet requirements have added 3 more fields which will
always be the same. But I do not wish to amend the database structure to
reflect the new fields if possible.

Can I amend the query somehow to default to the new fields?

For example current query like:

Field: surname address passportno dob

table: person contact person person

Can I add the following to the query without reference to any table:

field: Sex Nationality

which will always be:

Sex = M Nationaltiy= British


Thanks in advance.

Martin Hopkins

 

[Rick Brandt]

Could anyone help please.

I have a query that exports data to an Excel spreadsheet ready fro
onward transmission to another department.

However the spreadsheet requirements have added 3 more fields which
will always be the same. But I do not wish to amend the database
structure to reflect the new fields if possible.

Can I amend the query somehow to default to the new fields?

For example current query like:

Field: surname address passportno dob

table: person contact person person

Can I add the following to the query without reference to any table:

field: Sex Nationality

which will always be:

Sex = M Nationaltiy= British

Sure. Just enter the field names you want into two unused columns in the
query designer followed by a colon and then the value you want in the
query's output...

Sex: "M" Nationality: "British"