How to create Day reports (1 Viewer)

[talluri234]

Dear friends,

iam using access in my office daily work status reports

in this table fields like,

startDate
Ward no
Map no
Auto No
Filedspecilist Name
crew leader name
crew members present
crew member 1
crew member 2
crew member 3
No Of trips Coverd
Si Name
SI Acknolodgement
Citizen 1
Citizen 2
Citizen 3
Citizens acknolodgement
Notes
daily i entering eighteen rown how to print only that day eighteen rows

plese solve my problem plese..

i have prepared one report that report all dates r coming.

so pls help
my mail id talluri234@gmail.com
Cell:+91 9246 155817

Thanks&regards
Anil Talluri
Hyderabad
India

 

[mithani]

Creat command button and write below code in ON CLICK EVEN

DoCmd.OpenReport "Report name", acViewPreview, , ([TableDateField] Between #" & Me.StartingDate & "# And #" & EndingDate & "#)"

 

[talluri234]

dear nithani

thank u for sugession,

but not comming report

so pls send code brifley once again

thanks&Regards
anil

 

[mithani]

Open attached DB and see form "NewForm"

mithani

 

[talluri234]

dear mithani,

i see your db (new form)

report not buld ,


pls verifly once again sir
thank for ur fast reply


thnks &Regards,
Anil

 

[mithani]

I have tried and its working with me. Are you giving proper date format dd/mm/yyyy

 

[mithani]

See attached JPG. Its working with me.

 

[talluri234]

Dear sdir,

in my system Date formate comming in DD/mm/yy only

How to change date formate

Thanks&Regards
Anil

 

[talluri234]

dear mithani sir,

thank u sir,
got it

thank u very much sir,

thanks &Regards,
Anil