daily production report

[torehan]

how can i create a dailly production report?

 

[dkinley]

Not sure what you mean because many specifics are overlooked. A daily production report to one person could be defined differently by another. The report wizard may or may not work based upon the definition requirements. In order to get you started, here are some links to help that include report building:

http://www.techonthenet.com/access/index.php
http://www.sienaheights.edu/personal/csstrain/Access2007.htm
http://knol.google.com/k/andrew-comeau/data-entry-in-microsoft-access/35v6n7dr8r5i3/7#

Good luck with your project. If you have any problems, please post back!

-dK

 

[torehan]

thanks for your response.

i'm a newbie in access and day by day i discover more properties on it.

i was triying to get a report that contains daily production data. the difficultiy for me was the date range of report. i create a query and and add a criteria to date column " =date() " so that everytime the query begins it takes the data which is "production date" equals which date we are in.

Thank for your help, links seem very useful.

ToreHan

 

[dkinley]

I see. That will work for the current date, what if you wanted to repeat a production report for some date other than today?

In the QBE criteria, you could use: [Please input date]. This will give a popup for the date requested. What I do, and from what I've read about others, is use a form that requests information from the db user. In this manner, you can ensure the user is inputting the correct information to filter the query prior to executing the report. Then, in the QBE, you could use Forms!frmFormName!txtControlName to reference the criteria (as long as it is not complex criteria).

There are other ways around this if the report is bound directly to a table. The command (VBA behind and OnClick for a command button) for opening the report can include the criteria to filter the report.

For a range of reports, you could use two unbound controls for a start date and an end date. Reference the form controls with the Between command in the QBE and you can pick up records that are in a range of dates. Again, many ways to get the data that is required for you ....

Those links should go through some of these techniques and provide pictures to help you better understand.

Good luck and post back if you have problems!

-dK

 

[torehan]

Thanks for the expanded information.

My Access knowledge expanding day by day and the problems getting bigger and bigger

I disturb you if i will have problems.

Thanks very much.

Tore Han

 

[dkinley]

You betcha.

-dK