Re: Multiple Locations

On Tue, 26 Sep 2006 09:31:02 -0700, A Boy Named Joe
<ABoyNamedJoe@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Thanks for your reply Duane,

I've tried a couple of times off and on (more off than on) to get the query
to run but I keep getting the following message "Syntax error (missing
operator) in query expression 'First (Bin Location Table.Bin)'. The table
which lists the part numbers and bins is called 'Bin Location Table'. Any
suggestions?

If you (unwisely, in my opinion) use blanks or other special
characters in table or field names, you MUST use square brackets to
delimit the name. Otherwise it's seeing Bin as one word, Location as
another, Table.Bin as a third.

Try changing all instances of Bin Location Table in your query to [Bin
Location Table].

John W. Vinson[MVP]
.

Relevant Pages

  • Deleting a record on a form.
    ... I have created a database that tracks bin location based on item numbers. ... table "bulk bins" and a Primary "picking_seq" which is stored in our ERP ... I have several forms that query the data in differen't ways. ...
    (microsoft.public.access.forms)
  • Re: Update Query only works first time
    ... Parts and Supplies is not a query it is the table in which the Bin Locations ... Microsoft Access MVP 2006 ...
    (microsoft.public.access.queries)
  • count individuals of a certain sizes in one query
    ... My suggestion applies to the QBE grid view rather ... The bin name expressions I suggest would go into ... query, but will have no effect on your original data. ...
    (microsoft.public.access.queries)
  • Re: Update Query only works first time
    ... I will assume you have an autonumber field in your Parts and Supplies table that I will refer to as PartID. ... Rather than making 6 Bin fields in that table, what you should do is set up another table for Bins ... Microsoft Access MVP 2006 ... I don't know either -- but that is what you error message says -- perhaps you are not using an updateable recordset or records were locked by something else like a form or query ...
    (microsoft.public.access.queries)
  • count individuals of a certain sizes in one query
    ... My suggestion applies to the QBE grid view rather ... The bin name expressions I suggest would go into ... >query, but will have no effect on your original data. ... No need to apologize for lack of knowledge - we ...
    (microsoft.public.access.queries)