By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,790 Members | 1,398 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,790 IT Pros & Developers. It's quick & easy.

assigning a value in a query

P: n/a
how can i set a field to some value on the query design (so that field
always has the same value when the query is launched).

I tried to put the value in the criteria but it doesnt asign it

help please

Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Format is FIELD_NAME:VALUE. In the FIELD row of the QBE grid assign a
field name (ex. variable1, MyField, etc.) and then the value you want
separated by a colon. For text values enclose the value in quotes, for
numberic, list the number you want.

MPP

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #2

P: n/a
aaaaaa <aa**@ntlworld.com> wrote in message news:<47*****************@newsfep2-win.server.ntli.net>...
how can i set a field to some value on the query design (so that field
always has the same value when the query is launched).

I tried to put the value in the criteria but it doesnt asign it

help please


Hi!

This should be fairly straight forward. If this is a field that
already exists:

Go to the QBE screen (where you created your query)
In a blank field, type MyField: "Value"
MyField is the field that you want to set to a constant value
Value is the value that you want to assign to it.

(If you want to create a new field that remains a constant value,
MyField should be a new field name.)

Good Luck!
Nov 12 '05 #3

P: n/a
Thanks

Michael Pitman wrote:
Format is FIELD_NAME:VALUE. In the FIELD row of the QBE grid assign a
field name (ex. variable1, MyField, etc.) and then the value you want
separated by a colon. For text values enclose the value in quotes, for
numberic, list the number you want.

MPP

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


Nov 12 '05 #4

P: n/a
Ray
aaaaaa <aa**@ntlworld.com> wrote in message news:<47*****************@newsfep2-win.server.ntli.net>...
how can i set a field to some value on the query design (so that field
always has the same value when the query is launched).

I tried to put the value in the criteria but it doesnt asign it

help please


Hello aaaaaaa,

Just make a column in your query like this:

AlwaysSameValue: "Same Value"

Then, run the query and you'll always get the same
value for every record every time.

Regards,

Ray
Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.