Search results

Thanks, will do that. I won't even ask what single/double precision data types means...I will find that out as I go. 'preciate all your help.

You are absolutely right. And, that would be a nice thing to do, one I haven't considered. However, the people inputting this are not consistent, and I can't force them to. The important feature is the monthly tracking, and to a lesser extent, daily tracking in regards to forecast, etc. One...

Yes, I know, but daily data may not be entered daily, but weekly, every other day, etc. So for example, if a user enters data daily, then it could be a total of daily data. But if, however, a user only enters it one time, they would enter it using the last day of the month and I could...

I think I am catching on a bit. Entering month end data not by month and year, but by any day of the month (probably last day) will still enable me to pull monthly or yearly data. Therefore, all I need is an "order date", or in my terms, sales date, in the performance table. One other...

The daily data may or may not equal the monthly data, and is not necessary to match exactly during the month. It may not be input on an every day basis, or may have to be input for previous months, or may not be input at all on a daily basis, but the month end will be. It still seems to me...

Can it be that simple? I will try it when I get back to my database at home. If it is that simple, don't think of me as stupid, only ignorant. Thanks!!

I am designing a database to enter daily/monthly performance numbers for employees and department totals. However, I don't want to have to enter the month and/or day for every category for each employee entered. In looking through these forums, nobody recommends a separate date table. But it...

I wasn't looking for somebody to build me a complete database--I asked if I should include a Months/year table, was my thoughts on the setup going in the right direction, and did any of the sample databases fit what I am looking for (I understand that I would need to customize for my own...

I'm outta here, close this thread please.

I have an Excel spreadsheet that is 30 sheets that tracks sales and performance numbers for employees with charts, etc. and it is getting too big for me to handle so I am switching to Access--but I am an idiot on Access and this little round head can't visualize very well. Basically three...