start date & end date

[handsomealso]

Good Morning

I prepare database for recruting in company and they are many exame in recruting. And each exam in seprate day.
In the report if I want to print detailes in rang date (from - to).
How I can do this?

* I have many date in this database.

[June7]

You want to filter report so that only records between a date range are retrieved?

Apply filter criteria to date field of report RecordSource like:

BETWEEN [start date] AND [end date]

[handsomealso]

Thank You


But If I have Multi date field?
For example math exame, english exam....

[Parsonshere]

A multi value field is set up just like you would do it manually, only Access hides the tables. Can u unhide the tables, and you may see how to do this. I am not sure this is helpful, but I assume you can access these hidden tables just as if you had made them yourself. I see no reason for those myself, I always make my own because I always want to do more than just see a multi-value. You do this from the navigation pane by right clicking on the bar that shows the object type such as table, form etc. I attempted to attach a screen shot. I don't know if this will be helpful or not.

[June7]

I NEVER use multi-value fields. If you want to search on the multi-value field then query must expand the field so each value is a separate record, just as the data would be if stored normally. Review: http://office.microsoft.com/en-us/ac...010149297.aspx

How do you know what subject each exam date is for?

Or did you mean you have multiple fields? Do you have a field for each exam date? This is not normalized data structure and definitely complicates filtering/sorting.

[handsomealso]

Thank you

Yes I have multiple date fields.
When Students take exam we enter the date.

Thanks

[June7]

If you want to be able to filter for all the exams within a date range then would have to put the criteria under every date field but each on a separate row so the OR operator will apply. Will look like stair steps.

Normalized data structure would be like:

tblStudentsExams
StudentID
ExamName
ExamDate

Then there would be only one date field for range criteria.