how to hard code a value to a field?

[eeps24]

how can I hard code a value here? So for every row returned, it will have this value. I have a field called description. I want to put a specific value here so every line will contain that word.



How do i add that in design view?

[cbende2]

Is this just to display the value for a report?

Are you actually wanting the value in the table?

Are you wanting to have the default of this field to be this certain value?

[JoeM]

From your picture, it looks like this field ("GTR-DESCRIPTION") is already a calculated field, it is just set up to return a blank.
Just place whatever you want to be returned between the two single quotes, i.e.

GTR-DESCRIPTION:'My Text Here'

[eeps24]

When I run the report, I want every row to contain that specific value. Example, in that field I want it to say ARGL, so when I run the report, every row should have ARGL.

[eeps24]

JoeM, when I do that, i get "the expression you entered contains invalid syntax."

[JoeM]

If not single quotes, try double-quotes:

GTR-DESCRIPTION:'ARGL'

or

GTR-DESCRIPTION:"ARGL"

You are doing all this in the underlying query itself (and not trying trying to do it directly on the Report, right?)

[eeps24]

single quote worked! thank you, I am doing it in design view.

how do I mark this topic solved?

[JoeM]

how do I mark this topic solved?

See: https://www.accessforums.net/forum-s...lved-1828.html

[eeps24]

sorry guys, im back again. So when I type 'argl' (in design view) and run my query everything is blank. When I remove 'argl' then my query works. any thoughts?

[JoeM]

Look at what you have in the Field row:

GTR-DESCRIPTION:''

That means that you are hard-coding EVERY record to return blank for this calculated field.

Then you are entering 'argl' in the Criteria row.
That is telling Access to return every record where the field is equal to 'argl'. Since you set everything equal to blank, nothing meets that criteria and no records are returned.

If you are trying to hard-code the field to 'argl', you need to put this on the Field row, just like we showed up in post #6.

GTR-DESCRIPTION:'argl'

There shouldn't be a need to put anything on the Criteria row, as you aren't trying to limit any records selected here, but just trying to hard-code a value.

[cbende2]

sorry guys, im back again. So when I type 'argl' (in design view) and run my query everything is blank. When I remove 'argl' then my query works. any thoughts?

Refer back to post #3.