Results 1 to 14 of 14

Thread: Help with a Query

Hybrid View

  1. 12-27-2007, 02:14 AM #1
    ejjonesjr
    ejjonesjr is offline Registered User
    Join Date
    Dec 2007
    Posts
    8
    I figured it out, the issue was with JOIN. I had to use INNER JOIN. That works. However, Access is not letting me save the query now, which is weird.
    Reply With Quote Reply With Quote
  2. 12-27-2007, 01:27 PM #2
    nosepicker
    nosepicker is offline Registered User
    Join Date
    Dec 2004
    Posts
    502
    It's been a long time since I used Access, but if you're still having problems, you can possibly convert the subqueries in that statement (the parenthetical SELECT statements) into queries that you can INNER JOIN to in your larger SELECT statement.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules