I am trying to sum up all the value sof txt3 when a command button is
clicked, using DSum. The DSum is only to add up all the values that are with
in the current year (= whatever the year entered in the BegiinDate box).
The DSum is to goto the "MICU Information" add up all those = the same year
as in BeginDate (field is also called begin date in this table.
A faster alternative that I use, is create a sum query
that returns a single record and then do a Dlookup on that
query. I think that you will find this is a lot faster,
especially if you are trying to sum several thousand
records. Another advantage is that you don't need to
supply any criteria because it will automatically return
the first record.
I know this isn't what you asked for but it might be of
assistance anyway.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
