Report Calculation for vw

[vvwilson]

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 Boyce]

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

 

[vvwilson]

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.

 

[Jeff Boyce]

You only provided three named fields.

If you are saying you wish to add selection criteria on the date field in
your query, add selection criteria on your date field in your query (and
uncheck the "Show" box).

Regards

Jeff Boyce
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.

 

[Larry Linson]

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.