Access Date search output report

[ttbeverley]

Hello Again.

I have a database that i have created a report in, the data is exported to the report perfectly thanks to Boblarson.

Now i have another question. I would like to restrict this Report to a date range based on a user entered range. This will need to be very simple with user interface so that any end user can modify the dates.

I read a post from Thanos that had an example. this example is simple and very useful, but i cannot change it to apply to my data.

http://www.access-programmers.co.uk/forums/showthread.php?t=158555&highlight=date+range

If anyone can assist with this i would much appreciate it.

TT

 

[RainLover]

TT

What exactly is your problem. You have given us nothing to go on except that you have a problem. We have no idea what your data is.

Please explain.

 

[ttbeverley]

Sorry Ned Kelly,

yep... didnt explain well at all. Basically the form created and posted by Thanos was exactly what i wanted, but i couldnt figure out how to make it work FOR me.....

After a few hours sitting there staring at it, i got a friend in to bounce ideas off of, and i figured it out.

Basically using Thanos date report form i have changed the button to link to my own report title, and renamed the fields associated with Thanos example to become relevant to my own.

This has enabled the function to work.

Only issue i have now is that i can select a date, but that same field also has a time involved..... is there some way to search anywhere within that field for the date and ignore the time?

Between [forms]![FrmReportDates]![txtFrom] And [forms]![FrmReportDates]![txtTo]

This seems to be the section that is most important..... how do i allow for the variable time to be ignored and only take in to account the date?

Thanks

TT

 

[RainLover]

I think all you have to do is to format the text boxes to something like Short Date.

You can do this in the properties dialogue box of the Form.

Any problems please ask again.

edit an after thought

Are you selecting a date or are you entering a date. Entering as in typing 1/1/09