making report for specif data

[khanny608]

i am a beginner at access and really need some help.
i am try to make a database that allows you to put in specific dates and then it creates a report for that period of time.
the form should have the following fields
beginning date_______
finish date__________
view report

as i am an ameture i would be gratfull if you could give a step by step guide on doing this
i will be etternally grateful


the tables in the database are:
Employee

employeeid
name
surname
address



lecure

lectureid
module
course


Timming

Start time
finishtime
Date

i want to be able to see a report showing the empoyee and the lecture they are at for the dates that i type in

http://www.khanny608.com

 

[MHadden]

Since this is an old thread, have you gotten your answer yet? If not, let me know. It is easiest to use a parameter query, I'll give more details if you need them.

 

[sko]

Your current Timing table does not show how you are linking the records to the other tables. What's the primary key?

From your previous thread, your lecture table needs to include all available lectures along with the dates and times. Your Timing table needs to be redesigned as an Enrollment table.

tblEnrollment

Recordnum (Primary Key, autonumber)
Employeeid (Joined to the employee table)
Lectureid (Joined to the lecture table)