Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Record sets?
Hi I hope this will have a simple answer.
I have the following code. output = rs!age33 but what i want is to use a variable instead of age33 this is what i hoped would work but didn't and should make thinks clearer. lookup_age = 33 Query_Age = "Age" & Lookup_Age output = rs!query_age can anyone help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Record sets?
Please describe your recordset; specifically, what are the names of the fields and how it is created (via what query). Are you trying to return the results of the rs only where age = 33 (essentially filter your rs)? Regards, Bill "JJ" wrote: Hi I hope this will have a simple answer. I have the following code. output = rs!age33 but what i want is to use a variable instead of age33 this is what i hoped would work but didn't and should make thinks clearer. lookup_age = 33 Query_Age = "Age" & Lookup_Age output = rs!query_age can anyone help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open new record with selected fields from previous record | Excel Discussion (Misc queries) | |||
Excel graph 3 sets of data. 2 sets as lines 1 as column? | Charts and Charting in Excel | |||
Finding last record in month for each of several types of record. | Excel Programming | |||
Record Macro - Record custom user actions | Excel Programming | |||
Need help autopopulating next new record with previous record data | Excel Programming |