I have the following code which I cant seem to get to work correctly, it always shows me the last recordset instead of a zero when the recordset does not exist.
mysql = ("SELECT * FROM Morrisons WHERE [Date] = #" & txtDateS.Text & "#")
If Not rs.EOF Then
Do While Not rs.EOF
txtMorActS.Text = rs!DailyTotal
txtMorActS.Text = "0"