[MS_AccessPros] Query about DateDiff

 

Hello All,

I am working with Access 2010. I have a medical claim table. Within that table I have the following fields:

MedicalIDNo (Int)
ClaimNo (Int)
StartDt (Date)
EndDt (Date)

Within this table I can have multiple claims. I am trying to calculate the total number of days for each individual MedicalIDNo between the first StartDt and and the last EndDt. I know how to group them together, but I am not sure how to come up with one row per MedicalIDNo with the oldest date and the most current date.

Thanks in advance for your help.

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 3

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___