force a field just for display

  • Thread starter Thread starter djc
  • Start date Start date
D

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?
 
Back
Top