After Hours

Ask something
Discussion Locked

select by date

0 helpful
1 reply

by sziz 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

dear
I have problem if date 01/11/2014 in data records return =0 their are 2 records avl see my cod
Mprvstn = rs3!PRVSTN
Mdate = Format(rs3!EffDate, "dd-mm-yyyy")
rs.Close
rs.Open "select * from SHEDUAL3 where prvstn='" & Mprvstn & "'and EffDate=#" & Mdate & "#"
hrc = rs.RecordCount
thankes

1 reply

by john.a.wills

Your metalanguage is English, but so carelessly written that I do not know what you are talking about. I do not recognize your programming language, although it appears to be quoting SQL. Furthermore, this should be posted in the Questions Forum, not Around the Watercooler.

This discussion is closed to new replies.