By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,705 Members | 1,777 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,705 IT Pros & Developers. It's quick & easy.

MS Access Syntax Error

P: 1

New to microsoft access and need some troubleshooting help. I have a query with two tables: Bulk System Equipment & Interruption Data.

I need to search the Interruption Data for three fields where the "Switch/Breaker" fields are the same in both tables.

Here's what I did and returned a syntax error.

((([Interruption Data].[Switch/Breaker]=(SELECT [Int ID], [Time], [Station Name], [Switch/Breaker] FROM [Interruption Data] WHERE [Switch/Breaker] FROM [Interruption Data] = [Switch/Breaker] FROM [Bulk System Equipment])))

I know this might be a simple answer but I am new.

Thanks for your help.

Aug 6 '07 #1
Share this Question
Share on Google+
1 Reply

Scott Price
Expert 100+
P: 1,384
What version of Access are you using?

What does your table metadata look like?

Using my test db in Access 2003, I came up with this sql query:

SELECT Distinct tblInterruption.InterruptID, tblInterruption.Time, tblInterruption.StationName
FROM tblBulkSysEquip INNER JOIN tblInterruption ON tblBulkSysEquip.[Switch/Breaker] = tblInterruption.[Switch/Breaker];

Aug 6 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.