Tonight I spent 3 hours trying to get a simple, basic SQL query to work in Microsoft Access 2003. The SQL query runs perfectly in Microsoft SQL Server 2005, however when run through the VB code in Access via the DAO layer it kept on failing with a syntax error. Obviously the error message did not point out the cause of the error. Since the SQL was perfectly valid and not complex, I was baffled.

Here is the basic query I had written:

select sum([table one].[field1]) from [table one] inner join [table two] on [table one].[field2] = [table two].[field2] inner join [table three] on [table three].[field3] = [table two].[field3] where [table one].[field4] > '2005-01-01'

I have taken abstract photos of various things around my home. Try to guess what each photo represents. Use the Comment feature to name each photo.