Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MTD & YTD Summary on a form

Status
Not open for further replies.
rjf3123

rjf3123

Technical User
Sep 29, 2003
9
US
Relatively a newbie to MS Access ...

I am trying to develop a form that will have some statistical information.

Table: CheckDetails Field: EstRefund
Table: ClientTracking Field: InvoiceDate

Column 1 on the form shows the total EstRefund (have this).
Column 2 on the form s/b the total EstRefund for current year. (Don't have this).
Column 3 on the form s/b the total EstRefund for current month. (Don't have this).

I think DSum is the way to do this, but I am having a hard time figuring out the syntax.

Any thoughts??
TIA-
R. Fisher
 
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Locked
  • Solved
Subform not updating in parent form
Replies
10
Views
1K
Kennelbloke
Kennelbloke
breezett93
  • Locked
  • Question
Function that find all controls on a form and puts their tab index in numerical order
Replies
19
Views
1K
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Form Data Not Updating
Replies
6
Views
920
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Forcing Form Updates
Replies
2
Views
733
TrekBiker
TrekBiker
MattGreer
  • Locked
  • Question
Add Field Description to a Form 2
Replies
5
Views
587
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top