Temporary Variable

L

loo8866

Registered User.

Local time

Today, 03:52

Joined

Jan 11, 2007

Messages

106

• Feb 12, 2007

• #1

Hi There,

Is it poss to create a temp variable in a query. I want its value to be some text then a field:

"some text " + [name]

How do I create this in the query?

Thanks,

 

KeithG

AWF VIP

Local time

Today, 03:52

Joined

Mar 23, 2006

Messages

2,591

• Feb 12, 2007

• #2

In query column put the below

"Your Text " & [Name of Field]


make sure it is a text field

 

KernelK

Registered User.

Local time

Today, 06:52

Joined

Oct 3, 2006

Messages

173

• Feb 12, 2007

• #3

Goto Query Design View, in the Field row type a unique name for your new field followed by a colon ":" and then the expression you want calculated for the field. For example you could write: TempVar: "some text" & [name]
Thats it!

 

L

loo8866

Registered User.

Local time

Today, 03:52

Joined

Jan 11, 2007

Messages

106

• Feb 12, 2007

• #4

Thats excellent; thanks guys#!!