Re: need help with query

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Thu, 19 Apr 2007 11:09:16 -0500, gls858 <gls858@xxxxxxxxx> wrote:

Thanks for the input John S. I'm getting a invalid procedure call. I
think John V. called it right on this. I have some items numbers that
are only one digit that are causing the invalid call. Maybe if I did
a make table query and eliminated all items less than 3 digits first it
would work. Any idea how I could do that?

Don't need a make table query! Just add an additional criterion on the field

LIKE "??*"

John W. Vinson [MVP]
.

Relevant Pages

  • Re: newbie question: results by page
    ... I noticed that Message-ID: from John ... I get the same error again: Invalid ... >query: You have an error in your SQL syntax. ...
    (comp.lang.php)
  • Re: Query for Left(String,5) - Access 2007
    ... I think that is more what the OP wants, John, except boston.boston is the 5 ... digit field and Name.zip is the 9 digit version as I read the post. ... Note that this query cannot use the query design view, ... FROM ((boston INNER JOIN Name ON boston.Boston = Name.ZIP) INNER JOIN ...
    (microsoft.public.access.queries)
  • Re: need help with query
    ... John W. Vinson wrote: ... think John V. called it right on this. ... are only one digit that are causing the invalid call. ...
    (microsoft.public.access.gettingstarted)
  • Re: ???Invalid argument when doing make table query
    ... If I run a make table query, I got "Invalid argument" ... WOuld Appreciate advice ... Correct the error in your query. ... John W. Vinson ...
    (microsoft.public.access.queries)
  • Re: Corstabquery or normal query
    ... You can create the crosstab similar to the suggestion by John. ... church, also church elders, we have many elders, only 1st elder is one person. ... I would first build a query to get the data ...
    (microsoft.public.access.reports)