Counting days

[MaleNurse325]

Ah another one?

So I have s sub form called sfrmSickness

I would like to calculate the number of episodes of sickness absence in the last year. (=today()-365 days)

Thanks guys

 

[theDBguy]

In Access, you can use the DateDiff() function.

 

[plog]

This isn't a form issue. Not criticizing you for posting in the wrong sub, I just want you to learn to focus on what the real issue is. Forms and Reports are the things people see so they often conflate all issues with either of those. This is a data/logic issue.

For this data issue, we need more information. I don't really understand what you want to end up with. So can you explicitly tell me? You posted sample starting data in your first post, so please tell me what you hope to end up with from that starting data.

 

[MaleNurse325]

I have sorted the issue out. On the subform I needed to display some calculated fields.

 

[theDBguy]

I have sorted the issue out. On the subform I needed to display some calculated fields.

Good job! Glad to hear you got it sorted out. Cheers!