Query Colum not liked to table to display data

[blubomber]

I am setting up a Query and in one colum i want it to display a 1 in that colum but not link that colum to any table or other data source.

Thank you for any help.

 

[OnTheFly]

If you are using the query designer in Access, simply add this to a blank column:

FieldTitle: 1

If you are using SQL then add to the select part of the SQL statement:

1 AS FieldTitle

Where FieldTitle can be any string describing the value and not duplicating any of the field names in the tables.

Hope this helps.

OnTheFly

 

[blubomber]

Great, that worked and gave me the results i wanted.

Thanks for your help OnTheFly!