Recent content by dbarton

vbaInet, when data is entered in the tblTotals, it is a monthly totals, so for the month of June a single value of 100 may be entered. When they enter the to and from dates on the form, the limitation was they needed to enter the full month, 6/1/15 to 6/30/15. If they entered 6/1/15 to...

This is late in coming, but I want to thank vbaInet for his suggestion and that it did ultimately lead me to solving my problem. To generate the report, I did set up a form with user input of date range, then used these dates to pull in the data I wanted. What was missing was the logic to...

Greetings, I have two tables; one has just variances entered, the other is the total number of events for the month (normal events + variances). The variances become the numerator, and the total events is the denominator. The report does counts of variances based on location, type of variance...

I have been using MS Access since version 97 as an adjunct to my job. Most of my Access work was done in version 2003. Still not 100% comfortable with 2007-2010 versions. I find I use Access less and less, as my job has taken me towards other applications. I work in a hospital as the...