Ray Spackman
Registered User.
- Local time
- Today, 11:49
- Joined
- Feb 28, 2008
- Messages
- 52
Sorry if I missed this in another post, bit didn't see it when searched for.
I have a form that has a [EntryDate] date/time field formatted as LongDate. This form also contains several currency formatted fields.
I am using DSum to calculate one of these currenct fields but am wanting to show only the results for the month and year that equals that of the currently viewed record based on the [EntryDate] field of the currently viewed record. Is this possible, and how would that criteria look?
Thanks in advance.
I have a form that has a [EntryDate] date/time field formatted as LongDate. This form also contains several currency formatted fields.
I am using DSum to calculate one of these currenct fields but am wanting to show only the results for the month and year that equals that of the currently viewed record based on the [EntryDate] field of the currently viewed record. Is this possible, and how would that criteria look?
Thanks in advance.