Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

Access 2002: Sum by Date

  • Please log in to reply



    New Member

  • Member
  • Pip
  • 1 posts
I'm working with a form that I've developed for tracking time. In the form footer, I want to automatically display a running total of the time logged for today.
Column Name from the source table holding the data I want to sum: TimeSpent

I currently have a Text Box in the Form Footer with Control Source: =nz(Sum([TimeSpent])*24)

My time is calculating perfectly as I have it, but it is summing all data from TimeSpent; I want to limit what it is pulling to all records with Today's date.

My problem is that I'm learning as I go and don't have a background in SQL, so I don't know how to write the equation. Another option would be to query TimeSpent by today [Date()], but again, with the Source Table being the master table, I don't know how to call the Query and field to display in my Text Box.

Thanks for your help!

  • 0


Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP