Search the Community
Showing results for tags 'Year'.
If you have a Year with a single quote mark in it, like "1800's", then when you select that Year on the View tab you get an error like Syntax error (missing operator) in query expression '[Assets].[YearMade] = '1800's' AND [Assets].[LocationID] <> 3 AND ... Similarly, you get an error if a Color has a single quote. I did not test all of the views, but you don't get this error if a Manufacturer has a single quote in the name. I suspect that this error will occur for all of the views which don't use a database record to store the property, such as Warranty Expiration, Expiring Leases, Color, Year, and Made Of.