Query by parameter problem

  • Thread starter Thread starter Cindy
  • Start date Start date
C

Cindy

When I enter vendor information into the Parameter Value
dialog box, the box pops up a second time. I re-enter
the information but for some vendors, I get a blank
recordset. When I set up the database a couple of years
ago, the parameter box worked beautifully. After several
months, the second box began popping up, but the query
returned the desired recordset. Soon, a request for one
particular vendor's info returned a blank recordset, then
a second, and now most queries through this parameter box
return blank recordsets. Any ideas? Thanks.
 
When I enter vendor information into the Parameter Value
dialog box, the box pops up a second time. I re-enter
the information but for some vendors, I get a blank
recordset. When I set up the database a couple of years
ago, the parameter box worked beautifully. After several
months, the second box began popping up, but the query
returned the desired recordset. Soon, a request for one
particular vendor's info returned a blank recordset, then
a second, and now most queries through this parameter box
return blank recordsets. Any ideas? Thanks.
Click to expand...

Sounds like a corrupt query. I'd suggest:

- Open the query in SQL view
- Copy the SQL text out to a text file (via Notepad or another text
editor)
- Delete the query
- Compact the database
- Create a new query; copy and paste the saved SQL to the new query's
SQL view
 
Back
Top