I have been asked to somehow compile the average number of hourly transactions for 12 months of data broken down into months (spannig a fiscal calendar). The time stamp in my db is AM PM formatted e.g. 12:01:44 AM. Thinking that somehow I need to do a count for each hour and divide by the appropriate number of days in that month to get an average...any ideas...
Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
Any guidance is greatly appreciated...groovymonkey
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.
The problem with sub-reports and headings:
Add a dummy group to the sub report using the expression =1:
Set the “Repeat Section” property of the dummy…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…