force a field just for display

[djc]

Is there a way to add an arbitrary fieldName and value to the results of a
query?

for example lets say my query returns field1, field2, and field3 for a table
join. These are actual fields. Can I attatch a column at the end and give a
value of "MyValue" for every row?

Reason I ask is I have a few querys I need to put together for someone and I
would like to include the piece of criteria they supplied me in the output
as a visual reminder.

field1, field2, field3, MyFakeField

data1, data2, data3, jobNumber 10438*
data4, data5, data6, jobNumber 10438*
data7, data8, data9, jobNumber 10438*

etc...

anyone?

 

[Duane Hookom]

Just add another column with an expression like:
MyFakeField:"Display This"

 

[djc]

Great! thanks.

Just add another column with an expression like:
MyFakeField:"Display This"

--
Duane Hookom
MS Access MVP


give and