D
Deleted member 8621
Guest
I am trying for the first time to write a query in VBA because I can't get it to work in query desing do to my SELECT TOP [n] varialbe.
The problem is I can't seem to concatenate within VBA. Example
SQL statement in query desing view that I am trying to use:
WHERE ((([tblMeterData].[Model] & ", SN: " & [tblMeterData].[SN]) Like [Forms]![frmAdminEntry]![Text7]))
When I try to get this statement in VBA it will not take. I have tried singel quote: '", SN: "' and that didn't work.
Text7 looks like this:
Oce 9800, SN: 980101496
where Oce 9800 is the Model and 980101496 is the SN
Help
thanks
matthew
The problem is I can't seem to concatenate within VBA. Example
SQL statement in query desing view that I am trying to use:
WHERE ((([tblMeterData].[Model] & ", SN: " & [tblMeterData].[SN]) Like [Forms]![frmAdminEntry]![Text7]))
When I try to get this statement in VBA it will not take. I have tried singel quote: '", SN: "' and that didn't work.
Text7 looks like this:
Oce 9800, SN: 980101496
where Oce 9800 is the Model and 980101496 is the SN
Help
thanks
matthew