Recent content by johnmontgomery

I'll resist the temptation to sarcasm, and simply say, "Yes, I think the error message is telling me something." Depending upon the tool I'm using that parses, pre-compiles, and generates a query plan, which is different from COBOL with DB2, which is different from C with Sybase X (I'm dating...

Actually, I thought I was using a code from a query that is already in use here. However, now I have moved on, using your help--thanks. The next piece, which is the error I started my day with is in the FROM clause at the bottom of this big query. The first where clause in the FROM clause...

I have not been able to find a model for multiple joins, both inner and outer left, with where criteria. Here is the From clause that I am getting an error for: FROM (( Patron P INNER JOIN Patron_Address PA1 ON PA1.patron_id = P.patron_id AND PA1.address_type = '1') LEFT OUTER...

I am writing a query and attempting to use an inner join in a subquery that I am using for a column value. However, Access says the following has a syntax error. Select PATRON_GROUP.PATRON_GROUP_NAME from (PATRON_GROUP Inner Join PATRON_BARCODE on PATRON_GROUP.PATRON_GROUP_ID =...

Hello, I am a new member. I'm fairly new to Access, but have been writing SQL in various programming languages commercially for more years than I want to admit. My current role is in an academic library, and I need to use Access for data access, rather than writing a Java program or the like to...