How to create form in wich by selecting i can chouse wat kind of report i'll see.

[skocev]

I'm trying to make one smole app for my workers, sometingh like daily report from wich i can see where we have more oftenly problems and in wich department or machine. Now i have problems with adding totals to reports and filters for reports. My table look like this:
(DATE) (WORKER) (MACHINE) (DEPARTMENT) (START TIME) (END TIME) (TOTAL TIME) (TOTAL STOP TIME IN PROD.) (PROBLEM) (REASON)
so, everyday worker after every finished job have to fill this table. My problem is that i need to see SUM from (total time) colum in my reports. I try a lot of thing but i didn't make it as i wish. Allso i wish to make one form where i will chouse what kind of report i'll see, by worker, or by machine, or department or by total times. I need in each report to have sum of all total times. I need allso in each report to see sum of all (total stop time in prod).
I think that i explan enough but if you need some more information about this tell me.
Best regard, stojan

[objNoob]

Lookup the SUM() function.

And Lookup DoCmd.OpenReport. With a select case and .OpenReport, you can open any report selected from a drop down

[maximus]

I have done some thing for you

addressed thhe following problems:
1) sum Total Hours
2) Form to open selected Reports.

To find Date and time difference when you have adte and time in seperate Fields and are date/Time Fields

DateDiff("h",[Entry_Date]+[Starting_Time],[Entry_Date]+[Ending_time])

if they are store in text field then:
DateDiff("h",CDate([Entry_Date] & " " & [Starting_Time]),CDate([Entry_date] & " " & [Ending_Time]))

explore the database give me more details if you need any more help. will be glad to design the database for you.

[skocev]

Hi Maximus,
thanks for halping me. I see your example but that is not what i need. In attachment you hve my full database. The looks of tables, forms and reports is final. My problem is in "Preview reprt" form. I have put butons and commbo box so you can chouse what kind of report to view. It should to work like this:
Chouse type of report: daily/weekly/monthly/yearly. Then you chouse report by electrician or depatment or machine or you chouse to see full report. Report is open and if you wish you can print it or just close it.

This is all i need. All other tninks are done.

[maximus]

I will solve the problem and get back to you tommorow.

[skocev]

ok, thanks you.