sql query gives blank result

[kkshansid]

VHANDICAP = rs("HANDICAP")
strSQL = "SELECT MAX(AMOUNT) FROM TABLE WHERE VHANDI= " & VHANDICAP & "'"
Debug.Print strSQL
rs.Open strSQL, CurrentProject.Connection, adOpenKeyset, adLockOptimistic

sql query gives blank result for those employees who are not handicap
kindly help me to correct the error

[zmbd]

Line 3 gives a debug print.
Please run your code,
Presss <ctrl><g> to open the immediates window.
Copy the resolved string from that window to a post here, please format that information using the [CODE/] button.
(I suspect you're missing a quote mark)
Also any errors you are receiving.

[Rabbit]

You have a closing single quote for your handicap value, but you don't have an opening single quote.

[kkshansid]

sorry the query is

strSQL = "SELECT MAX(AMOUNT) FROM TABLE WHERE VHANDI= '" & VHANDICAP & "'"

it dont give error but provide blank result null value got from recordset is not null in query

[Rabbit]

Then you'll need to follow zmbd's instructions to find the query that is running

[kkshansid]

Select max(amount) 
from table 
where vhandicap=''

select * 
from table 
where vhandicap=''

both query gives blank record

[jimatqsi]

kkshansid, have you tried pasting this sql string into the query editor in SQL view and running tests from there? You could easily modify your query and check results instantly. After you know what query gives the result you want then you could work on assembling that query in code.

I'm wondering if the data is as you think it is. This simple test may open your eyes to something.

Jim

[jimatqsi]

As an aside, what is line 1 of the code in your first post about? It appears from that snippet of code that you are getting a value from a recordset that is not yet open.

Jim