Creating TempVars

[AlZheimer]

I’m trying to create a little database and then some reporting for it.

The scenario is as follows:
I import to my access dbase data from a CUBE

I add a date field using a query (that works)

I then need to select a field from a specific imported line and copy it into another field for all the imported lines.

To do so using a TempVar sounds like a good idea, please correct me if i’m wrong…

If I understand correctly, TempVars can only be created in macros?

I’ve tried all sorts of arguments using all sorts of syntax, by directly typing them in to the condition column or using the generator with no success:banghead:, can someone help me with the syntax.

Action column: DéfinirVarTemp (my Access is in french...)
Arguments column: tot_value; =

![Field_A]
Condition column: where ((

![Field_B]) like “[A]*”)
my condition being: Field_B’s first character must be an A.

or an alternative solution

Your help will be highly appreciated.

Thanks

 

[apr pillai]

Check this Link: Macros and Temporary Variables

 

[AlZheimer]

Many Thanks Apr pillai!

Great link with apparently loads of explanations that even I understand...