Re: Parameter query not working correct.

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

Open the table in design view.
What is the data type of the [loan number] and [load id] fields?

If Text, be aware that the matching may be affected by invisible formatting characters, such as spaces, embedded carriage returns, or null characters. Access also has problems matching fields that contain certain characters such as dashes.

If Number, make sure you declared the parameter (Parameter on Query menu, in query design) with the same data type as the field. (Do not declare the parameter for Text fields, as that can create other problems.)

If the number is a Double or Single, it is also possible that the display value is not the exact value, so the match does not occur.

It would also be worth compacting the database:
Tools | Database Utilities | Compact/Repair
just in case an index has corrupted.

If you are still stuck after that, post the SQL statement, indicate the data type and size of these 2 fields, and the specific values that fail.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jim Moberg" <JimMoberg@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A2EFEA83-0B11-4FDE-874E-60270E558F2C@xxxxxxxxxxxxxxxx

I have a query that joins table A to Table B via the loan number. Table A
contains a record for each loan and an associated load ID that it was
uploaded into our system under. Table B contains other information I need to
pull along with the loan number and load ID.

When run the query prompts the user for an upload ID. For one of the ID's
(1599) no data is coming up at all. I have opened up table A and verified
there are records in the table under that ID. I then opened up table B and
successfully did a lookup for one of the loan numbers under load ID 1599.

I have been 100% successful at entering other load ID's at run time and
pulling up data. I can't for the life of me figure out what is so different
about these records. Table A was created from spreadsheet of loan numbers
and load ID's that I created manually.

Can anyone think of what might be the cause here?

.

Relevant Pages

  • RE: Excel 2003 - VBA - Listbox on userform
    ... Where does MAXList get its value and what data type? ... I use the following routine to load the userform and when it trys to load ... 86 characters long, averaging around 60 characters. ...
    (microsoft.public.excel.misc)
  • Re: ntp server error
    ... STTY attributes for LOGIN ... EXCESSIVE LOAD ON PROCESSOR ... The processor is too busy to pull the characters out of the UART as fast as they are arriving. ... If your UART is so equipped, that says that for something like 16 milliseconds the processor has not read a character from the UART. ...
    (comp.protocols.time.ntp)
  • Re: No. of datatypes
    ... The best place to get all the data type will be SQl serevr Books online. ... Variable-length non-Unicode data with a maximum of 8,000 characters. ... Variable-length binary data with a maximum length of 8,000 bytes. ...
    (microsoft.public.sqlserver.programming)
  • Re: Webbrowser control not loading Html string
    ... If your HTML is longer than this then it won't ... You might want to allow some time for the page to load before opening it ... Wich generates a string with the data in a Xl sheet, ... the entire amount of characters], Non sucessfull, but i check out the code ...
    (microsoft.public.excel.programming)
  • Re: Reading GIF
    ... around that lets the programmer deal with a data type that Fortran ... signed integers than as characters. ... In theory, a compiler might not ... support 8-bit signed integers either, ...
    (comp.lang.fortran)