[CFTALKTor] Check Existing Date in Database

[Mike]

Hello All,   I am having a little trouble checking for an existing date.  I have a form that passes a date from calendar that I am using.  The calendar outputs the date as follows 6/13/2002.   So I have a few fields that I insert into the database along with that date.    There can only be one record per day.  I try to do a row count in the database before my insert statement to check if there is a row with that date value but I keep getting 0   The field that is passed from the form is dateofpayment and the field in the Access database is also dateofpayment     So I do    select count(dateofpayment) as rownum form table where dateofpayment = #form.dateofpayment#   I have manually entered the data in the table so there is already that date it should give me a record count of greater than one.    So I attempt to do a <cfif rownum gte 1> Go back to change the date </cfif>   But this is not working.  Does anyone have a better way to see if the date already exists with Access or can tell where my logic is flawed?   Thanks in Advance   Mike