Day, week, and month totals

[MrNoj]

I need to create a Database that will allow me to create a report of the data
by day, week, and month on one sheet. Each day has only one record, but there
are multiple fields in each record. Along the top of the report would have to
be a list of dates, with the field totaled for that week in a column along
the right side and the total so far that month totaled in the next column to
the right.
So far what I'm able to do is create the report to get the information by
day, but I cannot get the total for the week column or the total for the
month column to work for me by any means that I can figure out. I'm unable to
think of a solution that will be able to solve both problems at the same
time, only ones which solve one problem or the other, and those tend to leave
me with more problems in one way or another.
Pointers, hints, or even a slight nudge in the right direction would be much
appreciated.

 

[Steve]

I provide help with Access applications for a very reasonable fee. I can
create a database for your data and a report of the day, week and month
totals for you for a very reasonable fee. Contact me at (e-mail address removed) if
you would like my help.

Steve

 

[John W. Vinson]

I provide help with Access applications for a very reasonable fee. I can
create a database for your data and a report of the day, week and month
totals for you for a very reasonable fee. Contact me at (e-mail address removed) if
you would like my help.

Steve, your grubbing for paid work is inappropriate and unwelcome. Please
STOP.

 

[John W. Vinson]

I need to create a Database that will allow me to create a report of the data
by day, week, and month on one sheet. Each day has only one record, but there
are multiple fields in each record. Along the top of the report would have to
be a list of dates, with the field totaled for that week in a column along
the right side and the total so far that month totaled in the next column to
the right.
So far what I'm able to do is create the report to get the information by
day, but I cannot get the total for the week column or the total for the
month column to work for me by any means that I can figure out. I'm unable to
think of a solution that will be able to solve both problems at the same
time, only ones which solve one problem or the other, and those tend to leave
me with more problems in one way or another.
Pointers, hints, or even a slight nudge in the right direction would be much
appreciated.

I'm not visualizing the structure very well, it seems! You have "a number" of
fields - three? thirty? 243? Do you want all of these fields totalled by day,
week and month? Where does the "list of dates" across the top of the report
come from?

Could you post the relevant fieldnames and sample data of your table, and what
the desired report should look like?

 

[Jeff Boyce]

As John points out, it all starts with the data...

"How" to do something will depend on how your data is organized.

(by the way, participation in these newsgroups is "volunteer". Folks who
solicit work here do so in violation of at least the spirit of the 'groups.)

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[MrNoj]

:

I'm not visualizing the structure very well, it seems! You have "a number" of
fields - three? thirty? 243? Do you want all of these fields totalled by day,
week and month? Where does the "list of dates" across the top of the report
come from?

Could you post the relevant fieldnames and sample data of your table, and what
the desired report should look like?

The report was originally created in Excel, but it was rather difficult to
deal with for the people in my office, so I am trying to make it more user
friendly and have the whole thing in a database so that it can be accessed
later.

What I have now is a pair of tables;

compactTbl
date
day
numCust (number of customers)
onhand (cash on hand)
overage (register overage)
officeOverage (office overage)
etc...

detailTbl
date
deptX (15-20 fields where X=department number)
shortage (register shortage)
Xsupplies (about 5 fields where X=department)

The two tables have a 1-1 relationship with date as the primary key. All of
the data other than day, date, and the number of customers (day being the day
of the week) are currency values which need to be totaled first daily, then
weekly and monthly, with the totals from the daily report getting totaled by
week and month-to-date as well. The weekly number of customers and
month-to-date number of customers also need to be shown on the report.
I have created forms to input the data, and queries to get the needed
information totaled by day, and even a report that will show the daily
totals, but week and month elude me. I'm thinking that the problem lies in
the table design, but I don't know how to structure it better for the
purpose. I tried googling it, but I'm pretty sure that my search was
extremely vague, because I couldn't find anything even slightly related to
the subject. Like I said, pointers would be helpful, information would be
helpful, I'm kinda banging my head against the wall on this one.