Access

[Khanlala78]

Helloe, My boss have asked me to create a access database, where he needs me to add a calender in Query. And then click on any givin date to see the event for that day.

He also needs to me creat a query and see how many point a person has it from any date to any date. Calculation methong

Please let me know i will be really thankfull to you,.

Thanks

Alam

[DanInManchester]

Sounds straight forward enough. but wasn't sure about the second part of your request.

tbl_Events
EventId (Primary key)
Date
Name
Description

to get events from a particular date use a query like this :

SELECT * FROM tbl_Events WHERE Date = @EventDate

Can you explain how the points system works and I can perhaps come up with an example for that as well.