Error in code

  • Thread starter satty via AccessMonster.com
  • 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 )
 
D

Douglas J. Steele

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?
 
Top