CODEWITHSUNDEEP
sqlms-access
jdcoderocks
jdcoderocks

Reputation: 9

What can be written after table name dot in vba apart from column name?

I have following query, when I run this it asks for parameter value for 'Mike Account'. I don't have this column called Mike Account in customer table.

SELECT [Customer].[Name]
, [Customer].[City]
, [Customer].[Mike Account] 
FROM
([Orders] INNER JOIN [Customer] ON [Orders].[Customer Key] = [Customer].[Customer Key]) 
INNER JOIN [Inventory Master] 
    ON [Orders].[Item Key] = [Inventory Master].[Item Key] 
WHERE ((([Orders].[Order Date])<Date()-7) 
    AND (([Customer].[Account Manager])=[forms]![Main Console]![User]) 
    AND (([Quantity on Hand]+[BO Quantity on Hand]+[Quantity on Order])=0));

What can be 'Mike Account' apart from column name ?

Upvotes: 0

Views: 123

Answers (1)

Andre
Andre

Reputation: 27634

At this position in the SELECT query, [Mike Account] can only be a column name.

So it's either a typo, or the column was deleted or renamed.

Upvotes: 2

Related Questions