SQL String Text

[CarlM1975]

I have the following SQL but I can not get the me.assetsubasset into text format and therefore the statement does not run

Can anybody help?

Here is the SQL:

dbs.Execute ("SELECT [Reactive Scorecard Data].[Asset & Sub Asset], [Category Lookup Table].Category, [Reactive Scorecard Data].[Day Requested], [Reactive Scorecard Data].Asset, [Reactive Scorecard Data].Code, [Reactive Scorecard Data].JobCode, [Reactive Scorecard Data].Contractor, [Reactive Scorecard Data].Priority, [Reactive Scorecard Data].[True Requested At] INTO tblcarl FROM [Reactive Scorecard Data] LEFT JOIN [Category Lookup Table] ON [Reactive Scorecard Data].[Asset & Sub Asset] = [Category Lookup Table].Asset WHERE ((([Reactive Scorecard Data].[Asset & Sub Asset])=" & Me.assetsubasset)

I'm sure its all quote related but I cant seem to get them in the correct place.

Thanks

Carl.

 

[aman]

Remove the extra bracket marked in red below.

 WHERE [COLOR=red]([/COLOR](([Reactive Scorecard Data].[Asset & Sub Asset])=" & Me.assetsubasset)

and what is the data type of assetsubasset in the table?

Cheers

 

[aman]

Try the following. it should work fine if assetsubasset is number data type.

dbs.Execute ("SELECT [Reactive Scorecard Data].[Asset & Sub Asset], [Category Lookup Table].Category, [Reactive Scorecard Data].[Day Requested], [Reactive Scorecard Data].Asset, [Reactive Scorecard Data].Code, [Reactive Scorecard Data].JobCode, [Reactive Scorecard Data].Contractor, [Reactive Scorecard Data].Priority, [Reactive Scorecard Data].[True Requested At] INTO tblcarl FROM [Reactive Scorecard Data] LEFT JOIN [Category Lookup Table] ON [Reactive Scorecard Data].[Asset & Sub Asset] = [Category Lookup Table].Asset WHERE (([Reactive Scorecard Data].[Asset & Sub Asset])=" & Me.assetsubasset &")")

Cheers

 

[boblarson]

Just remove all of the parens (not needed):

WHERE [Reactive Scorecard Data].[Asset & Sub Asset]=" & Me.assetsubasset