MS Access Question 1
14 November 2002, 09:57 AM
#1
Scooby Newbie
Thread Starter
Join Date: Nov 2002
Posts: 4
Likes: 0
Received 0 Likes
on
0 Posts
Does anyone know how to get Access to accept a text sting as field reference eg Formula = [table]![field] where the field is a variable result from a filtered table
the example is Ex Rates: = "[DATA_Divider for 2002 YTD]![" & [Current Period]![Month] & "]")
[Current Period]![Month] is the variable field reference
[DATA_Divider for 2002 YTD]![Jan-01] is the ref I need to end up with.
the example is Ex Rates: = "[DATA_Divider for 2002 YTD]![" & [Current Period]![Month] & "]")
[Current Period]![Month] is the variable field reference
[DATA_Divider for 2002 YTD]![Jan-01] is the ref I need to end up with.
Thread
Thread Starter
Forum
Replies
Last Post
Brzoza
Engine Management and ECU Remapping
1
02 October 2015 05:26 PM