Adding a Field in a query

  • Thread starter Thread starter Haji
  • Start date Start date
H

Haji

Hi,

I am creating a query and I need to add a field name that
does not exist in my table. The field name will be a
persons name (i.e. Bob Smith). Is there a way to do
this? I am running serveral queries and then joining
them and I need a field in each query that is distinctive.


Thanks,

Haji
 
Do you mean a constant field (every row will have the same value)?

Just put "Bob Smith" as a field. If you're doing this in the query builder
grid, you might want to put a field name in front of the constant, something
like MyNewField: "Bob Smith"
 
Back
Top