Trouble linking tables filed for a support database form

[MarkMason12]

Hi all, New to this so bear with me. I am in the process of putting together a Helpdesk support call logging database. The form that I am using has "Date raised", "Target Date" & "Date Resolved", "Priority" fields. I would like to be able to create a query on this so it will highlight all calls that are over their target date? Please Help???????

 

[Krava]

Hi, Mark!

you can use a select query where you set up a criteria for TargetDate field e.g. <Date(), or you can also use the function DateDiff, it depends of the format of TargetDate field.

Krava

 

[MarkMason12]

Krava, thanks I will take a look and see what happens.