Export table data by dates

[Rakesh935]

Hello,

I am preparing a tool where in the user has to manually input the data on regular basis and the same thing (Table) must get exported to excel on weekly basis for reporting purpose.

So far everything looks fine but stuck in exporting the table data to excel by dates or any date interval selected by the user.

Requesting help in order to proceeds further in completing the tool.

Thank you,
Rakesh

 

[pwbrown]

After the user inputs the date in a form, use that inputted value in a query and export the query records to excel.

 

[Rakesh935]

Thanks pwbrown for ur inputs...

But actually what i was thinking of is calender control extraction from database..

Thank you

 

[pwbrown]

Sorry I actually misread your post, mistook "input the data" for "input the date". It was too early in the morning.
But it's the same sort of process, retrieve the date from the calendar control and use it in a query to select the records you want then export the query records to excel.

 

[Evangelina]

Hey you can use software for extraction.

 

[Rakesh935]

Hello Evangelina,

Well about what software are you refereing to...because i am still struggling to do this :banghead:.

Any help from anybody is much appreciated about the below requirement.

Thank you,
Rakesh

 

[pwbrown]

Any add on software will most likely have to be bought, no point when it's simple enough to do!
What have you done so far? Have you retrieved the date from the calendar control and used that in a query?
In the query criteria under your date field you would put something like:
Between [Forms]![Your form name here].[BeginningDate] And [Forms]![Your form name here].[EndingDate]