If record exist

[RickR]

Hello All,

I'm trying to find out if a record exists in a table. I have searched and found several methods, but I have not been successfull in making any of them work.

Here is how I want to implement it; I want to check in a log table to see if an archive has been made for a paticular month. The records are date fields.
If the date exisits I want to end the subroutine, if not, follow thru with it.

The variable I want to look for is
- Format(Date - 90, "mmmyy")

That way the archive will only take place once a month.

Thanks a lot for the help,

Rick

 

[David R]

Try the Dcount function. If it is greater than 0, the record exists.

Example: If DCount("FieldName","TableName","FieldName = #" & DateInQuestion & "#") Then...