Variables in query field

[saechaoc]

I want this to always call the last month but it does not evaluate the formula instead it treats it as an expression.



[Logility_Table]![ACTD Format(DateAdd("m",-1,Date()),"m/yyyy")]

This Format(DateAdd("m",-1,Date()),"m/yyyy") by itself brings in 8/2015 and I want [Logility_Table]![ACTD 8/2015]

Any ideas on how to dynamically query this data or would it be better to make a SQL string in VBA?

Thank you.

[June7]

Cannot reference table/query directly like that. Options are to join tables in query or domain aggregate functions (DLookup, DMax, DMin, DSum, etc) or open recordset in VBA.

Where are you trying to do this?

[saechaoc]

Thats good to know thank you ! I'll just do it in VBA then which should work correct?

[June7]

If you still have issues, post your attempted code for analysis.