Query Literal string

[David44Coder]

I found this from a Google search

Literal strings are enclosed in single or double quotation marks.
You can use literal strings just like you normally use a column name in the SELECT statement. The literal string will be displayed in very row of the query result.

And this is proven in query result. But if a Form is based on that query, there's a prompt to enter it, rather than just use it.
Is there a way around this?

 

[June7]

There is only a prompt if you enclose in [ ]. That should prompt even if not used as form RecordSource.

Post your query SQL.

 

[Gasman]

Works for me?, using single ot double quotes?

SELECT TestTransactions.*, 'Name' AS TestField
FROM TestTransactions;

 

[David44Coder]

Apologies.. can't duplicate it now and it's working here too.