Access Reports

[WhatnThe]

I want to run a report of data in one of my tables. I need to run a report based on a date. How can I generate a report that asks for a date before giving a report?

[RuralGuy]

Why not have a "Run-a-Report" form that asks for a date and then passes the value to the Report or query?

[WhatnThe]

Will show you want I have later RuralGuy you can see what I have. I am not doing something right. Sorry for the late replay, but I have had a lot going on over the last few days.

[WhatnThe]

I combined the two threads. RG - Moderator

I have already started a thread with the same question, but I was unable to locate & add to it so I started a new thread.

I have uploaded a sample of my database, I want to create a report based on one of my tables. My data entry form is used to add daily info on the jobs we run, i.e part number, quantity ran, pieces produced, & scrap.

I need to be able to generate a report based on dates and job number. I mean if I want to see out scrap rate I want to be able to select a date range and job number and generate a report based on that. Is there a way to be prompted to enter the information and then get the report from that?

Is it possible to create a form you where you could input the data you want in the report?

Are there any examples I could take a look at?

[WhatnThe]

Why not have a "Run-a-Report" form that asks for a date and then passes the value to the Report or query?

Is it done the same way as the data entry form?

[RuralGuy]

Is it done the same way as the data entry form?

Pretty much, yes.

[jbarrum]

you could just go to the query that the report is built off. Open the query in design view and on the date field put in the criteria [enter date]. Include the brackets. The information you put in the brackets is mearly what will show as prompt when the query is ran. As long as your report is built off of this query it will prompt the user to enter a date.

[RuralGuy]

One of the big advantages of using a form is you can use a Calendar control such as one of these to get the value and eliminate input validation.

[jbarrum]

great point.

[WhatnThe]

I will give it a try and let you know how it worked out for me. Thanks all

[carlmdobbs]

I want to run a report of data in one of my tables. I need to run a report based on a date. How can I generate a report that asks for a date before giving a report?

Simply make a parameter report as its recordsource. It will ask for the date with a pop-up box when it is opened. You can also do it in VBA code if you want a field on a form to do it. If you want me to explain it in detail you can call me at 301-534-6056 after 7 tonight and I can talk to you at length. I'm Carl and my email is carlmdobbs@gmail.com. I am a professional tutor but you get advice free for this blog answer.

[WhatnThe]

I am having a little difficulty with the using creating an access form to generate a report based on its content. Could anyone point me in the right direction.

I did use "jbarrum" suggestion [What date] but this pointed me to another question. When I generate a report is there a message I can add is there is no information to be displayed?

Also would it be possible to use a word template to the report that gets generated?

I would really like to use a form to do what I am looking to accomplish so any help with this would be helpful. I could upload a sample of my database if that would help.

[carlmdobbs]

Open the form whose information you want in a report. Click the blue ball at the top of the screen if this is made in Access 2007. Click "Save Object As". It will prompt you for a new name. The drop-down list allows you to save it as a report.

[WhatnThe]

I am still having issues with creating a form that will allow me to run a report. I don't know where to locate the code nor can I find an example that will show me the code in action.

I would appreciate any assistance.

Basically what I have tried to do is create a form where I can run a report based on any or all values imputed into the form. Can anyone point me in the right direction?

[RuralGuy]

It looks like you have not even started to open your report. If you make the attempt we can offer suggestions on what to change to get it to work.