Sql Record Select with multiple fields

[ianclegg]

Hi

Can anyone help?

I am trying to identify selective records using vba and sql and am unable to select the correct records using my code. I have a table containing the records fro selection having the fields JobNo and Code which in all records the criteria for selection.

The code reads

input #1, contract,Porderno,depotname,Pnims

sql="select * from Jobs where jobno = '" & Porderno & "' and code = '" & Pnims & "'"

On running the code my query never finds the records based on the 2 fields, it only appears to work using the first field.

All fields in both the table being queried and the parameters being fed contain the correct data.

Any help would be appreciated.


Regards


Ian Clegg

 

[llkhoutx]

Are both of the filtered parameters alpha? One cannot tell from your posting.

Interger parameters are not enclosed with tic marks.
Date parameters are enclosed with #.

 

[ianclegg]

Hi

The jobno is numeric eg. 5000005589 and the code is AlphaNumeric eg N573


Regards

Ian

 

[jal]

As the other poster said. You don't want quotes around numeric fields


sql="select * from Jobs where jobno = " & Porderno & " and code = '" & Pnims & "'"