Re: Syntax Error

5 Tables is too many? should I break it down into 2....its just that it
would leave me needing like 50 fields in order to enter all the fields I
need. I am thinking I should just hire someone to do this....cause I just
don't get it!

Thanks for your help....looks like I will start from scratch.

Kara


"Rick Brandt" wrote:

> Kara wrote:
> > Ohhh Rick I feel one step closer thanks! LOL
> >
> > K...here is my SQL thingy (not the technical term I know ....)
> > SELECT
> > FROM (([Drop Down Lists] INNER JOIN (Customers INNER JOIN [Inventory
> > Used] ON ([Inventory Used].[Customer ID] = Customers.[Customer ID])
> > AND (Customers.[Invoice #] = [Inventory Used].[Invoice #])) ON ([Drop
> > Down Lists].ID = [Inventory Used].ID) AND ([Drop Down
> > Lists].[Carpentry Hours] = [Inventory Used].[Carpentry Hours])) INNER
> > JOIN [Job Information] ON ([Drop Down Lists].ID = [Job
> > Information].ID) AND ([Job Information].Township = [Inventory
> > Used].Township) AND (Customers.Township = [Job
> > Information].Township)) INNER JOIN Employee ON Customers.[Order ID] =
> > Employee.[Employee ID];
> >
> > Now what? LOL
>
> That is an invalid statement (hence your error). There should be field names
> listed after "SELECT" and before "FROM". If you are familiar with building
> queries I would delete the entire statement and then click on the build button
> [...] to the right. That wil bring up the query builder which you can use to
> create the query over again properly. If you are not familiar with building
> queries I would rebuild the form over agaon from scratch using the wizard.
>
> By the way, a query using that many tables will most likely be Read-Only so if
> you wanted the form to be able to edit records there's a good chance that it
> will not work.
>
> --
> I don't check the Email account attached
> to this message. Send instead to...
> RBrandt at Hunter dot com
>
>
>
.