Error in code

  • Thread starter Thread starter satty via AccessMonster.com
  • Start date Start date
S

satty via AccessMonster.com

can anyone know why this doesnt work??

"FROM tbl_Tax_periods INNER JOIN tbl_Options_periods ON (tbl_Tax_periods.
TAX_PERIOD_ID = tbl_Options_periods.OPTION_TAX_PERIOD_ID) AND
(tbl_Tax_periods.TAX_PERIOD_ID = tbl_Options_periods.OPTION_TAX_PERIOD_ID)
AND (tbl_Tax_periods.TAX_PERIOD_ID = tbl_Options_periods.OPTION_TAX_PERIOD_ID)
AND (tbl_Tax_periods.TAX_PERIOD_ID = tbl_Options_periods.OPTION_TAX_PERIOD_ID)
AND (tbl_Tax_periods.TAX_PERIOD_ID = tbl_Options_periods.OPTION_TAX_PERIOD_ID)


i'm getting an error saying - Compile Error - Expected: List seperator Or )
 
What's the rest of it? I'm suspecting you may have opened a parentheses in
the earlier bits that hasn't been closed.

On the other hand, why are you repeating tbl_Tax_periods.TAX_PERIOD_ID =
tbl_Options_periods.OPTION_TAX_PERIOD_ID 5 times?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find as you type question 0
Calling Error Handling in VBA 1
what causes an error that says: "Too few Parameters. Expected 1." 3
Windows 10 Error: 'CreateProcessWithTokenW' was not declared in this scope 2
What is wrong with this code? 5
Anyone Else Facing Public Folder Migration Errors in Exchange? 0
code help... 1
DSum Problem 2

Back
Top