this may code show 0 records where 1200 records
the filed = shorte date
Code:
mmonth =format( rs!EffDate,"mm/yyyy")="10/2014" rs.close rs.open"select * from Shedual where EffDate=#" & mmonth & "#" Talroc=rs.recordCount=0
aziz sonnari
Last Activity: Feb 13 '15, 05:05 AM
Joined: Dec 10 '13
Location:
-
select all records under mm/yyyy
Hi I want to select all records under mm/yyyy from access table
this may code show 0 records where 1200 records
the filed = shorte date
thank youLast edited by Rabbit; Feb 6 '15, 06:04 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data. -
how to select date
dear
I am working with vb project but facing difficulty in getting Records = 0 if date 01/11/2014 when I check database found 2 records see foolowing code
Mdate =Formaat(rs3!sh edual,"dd/mm/yyyy")
rs.close
rs.open"select * from shedual where EffeDate=#" & Mdate & "#"
thank you
No activity results to display