Adding Static Fields To A Select Query

[paulS30berks]

I wish to add a static field to a select query i.e a field that does not exist within a table.

Does anyone know how I can do this?

Thanks

 

[reclusivemonkey]

Use in a spare select query field;

Field Name: "Field Value"

You can enter a value when the query is run by using [Enter your variable] and on executing the query, the user will be prompted with a message box with whatever you enclose in square brackets. You could also add your variable from a field on a form.

 

[paulS30berks]

Thanks for your reply.

I wish to add a static field called State and include with value

 

[reclusivemonkey]

How many values for State? If its more that one, then its not what I would call a static value. I would say a static field is the same, regardless of the record it is in. If this isn't a case, you need to include this field in your table, not as a "static field".

 

[paulS30berks]

works fine.

Thanks