Originally Posted by
dehdahdoh
Thank you for your help, now I am getting a different and I am not going to pretend that I know how to fix it. Th error is "Syntax error in FROM clause." Below is the SQL that is associated with the Query.
SELECT Dog.Order, Dog.Sex, Dog.[Owner 1], Dog.[Owner 2], Dog.Address, Dog.City, Dog.State, Dog.Zip, Dog.Date, [Entry - Classes].[Reg#], Dog.Breed, [Entry - Classes].Class, [Entry - Classes].Order, Dog.Jump, Dog.[OB Jump], [Entry - Classes].[Armbd#], [Entry - Classes].Club, [Entry - Classes].Entr, Dog.Title, Dog.[Dogs Name], Dog.[S-Title], [Entry - Classes].Show1, [Entry - Classes].Show2, [Entry - Classes].Show3, [Entry - Classes].Show4, [Entry - Classes].Entry_Fee, [Entry - Classes].Fax_Fee, [Entry - Classes].[$Rec'd], [Entry - Classes].Balance
FROM Dog INNER JOIN [Entry - Classes] ON Dog.[Reg#] = [Entry - Classes].[Reg#], FROM Dog INNERJOIN [Entry - Classes] ON Dog.[Order]=[Entry Classes].[Order]
WHERE ((([Entry - Classes].Class)>="01" And ([Entry - Classes].Class)<="90"))
ORDER BY Dog.Order;