RE: Pulling a parameter from a form

it should look like that

in ("vb1","vb2","vb3")

Where (Take_Offs_tbl.House_Code) in ("vb1","vb2","vb3")

"jokeascool" wrote:

> Hello All,
>
> I have query that pulls a parameter from a list box on a form. The
> query refrences the list box like such:
>
> Where (Take_Offs_tbl.House_Code)=[forms]![frmschedulea]![listbox8]
>
> My question is this.
>
> I have a for next loop that concatenates the parameter. What is the
> proper syntax that the parameter should look like after the loop is
> done.
>
> Should it simply look like this:
>
> "vb1"or"vb2"or"vb3"
>
> Or should it look differntly. Right now the query is not working
> correctly and it has something to do with this parameter.
>
> Any help would be appreciated!
>
> Thanks
>
> Joe
>
>
.

Relevant Pages

  • Re: LOOP WITHIN A LOOP
    ... Assuming you can define a set of forbidden values, a Query is probably the easiest way to go. ... But your criteria could be trickier than just an easily listed set. ... Public Function DataScore(_ ... The reason I asked the loop within a loop question was so that I can loop through all of the fields for each record anh have a running score. ...
    (microsoft.public.access.tablesdbdesign)
  • JDBC: Retaining multiple result sets from a query made in a loop
    ... I'm planning a small Java app using JDBC and have question about making ... My program will make a query once and then use one of the fields from ... Make a single query and get the results in result set RS1 ... This will not work since each trip through the loop destroys the ...
    (comp.lang.java.databases)
  • Re: fiter records in class module
    ... You can run a temporary parameter query from a module. ... allows you to keep changing criteria in a loop. ... For help with creating an SQL string for your database, ... ' See if recordset contains records: ...
    (microsoft.public.access.modulesdaovba)
  • RE: Exporting to Excel
    ... The OpenQuery call in the Loop seems to be critical. ... Static Function GetUserIdAs String ... 'Open the specific query with the data to be exported ... You can use this to drive a loop that will export a worksheet per userid. ...
    (microsoft.public.access.externaldata)
  • Re: Converting from Access to SQL2k via Excel- HELP!!!!!
    ... Then create a new query and paste the following into its SQL ... > In your database you'd need to start with a query that ... The function that you pointed me to allows me to concatenate all ... The problem that I have is that I need to put it into a loop ...
    (microsoft.public.access.conversion)