Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 01-22-2004, 02:03 PM   #1
billyw1953
Junior Member
 
Join Date: Jan 2004
Location: San Angelo, Texas
Posts: 13
Thanks: 0
Thanked 1 Time in 1 Post
billyw1953
Jon K You're A Life Saver

It was probably fairly routine for you, but I cannot express to you and the others that answered my post just how much I appreciate your help. My database is working perfectly now that the total time issue has been resolved. I read quite a bit before I ever posted and one of the things I keep seeing over and over is "normalization". I think I am off to a good start because I designed it with just that in mind. It contains many tables that are structured to hold only data about a particular subject so as to reduce redundency and duplicate records. At least that is my understanding of "normalization." I believe this database will evolve into a useful tool for my replacement after I retire, if I can at least begin to understand these funtions and the power they have if applied correctly. I will continue to try, and may be back another time to ask for help and possibly later down the road I might be able to contribute as you folks have.

I have attached the last page of a 5 page report which shows exactly what I need to see in order to make an informed decision about a location. I re-calculated all the hours and thanks to you the times are correct regardless of whether it is a daily, weekly, monthly, quarterly, or yearly report.

Thanks again for baby stepping me through this, if you're ever in San Angelo, Texas dinner is on me.

BWard
Attached Images
File Type: jpg capture2.jpg (72.0 KB, 121 views)

billyw1953 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 06:58 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World