Karnack is having some difficulty seeing your database, even though he is
holding your post up against the turban on his forehead. Perhaps, if you
were a little more precise in describing your data, what you are trying to
do, and what you would like to happen, some Access person who is not a
psychic would be able to make a suggestion.
It's not just a matter of what you enter, and what you want to see. It is
what data you are storing , what form you are storing it in (with details on
type), what fields you want it grouped by, etc. Really, we can't see your
database to pick up the details -- really.
Larry Linson
Microsoft Office Access MVP
I'm having trouble visualizing your data structure... and it all starts
with
the data! "How" depends on how you've organized your data.
Something that does occur to me, though, is that you might be able to use
a
Totals query to dynamically calculate the "job to date sum of hours",
rather
than what sounds like saving an running total-to-date.
Regards
Jeff Boyce
Microsoft Office/Access MVP
I have a report called Daily. I use it to track the hours worked by
our employees. In the form that generates the report I have a field
called total hours to date. I am currently looking up the previous
day’s hours and adding them to current days hours in order get the job
to date sum of hours. What format can I use to show the job to date
sum of hours in my report without having to manually entering it into
my form. Take into consideration the fact that I will sometimes need
to refer to previous dates
Jeff, I enter in about 30 employee numbers along with hours worked and
date each day. So visualize a table with four fields. txtemp,
txthours, txtdate . In my query I am grouping the date and requesting
sum for txthours. I am not using txtemp at all in the query. The
query results give me the date and sum of hours for each date. What I
am interested in seeing when I open my report is the sum of all hours
note to exceed the date entered as a perameter value. ex. enter
5/29/2008 see 5/29/2008 4684098 instead of 5/29/2008 120.