Microsoft Access Database – Working With Two Digit Hour Time Formats

Microsoft Access Tutorial – Working With Two Digit Hour Time Formats

Here’s a quick Microsoft Access tutorial video I found about applying formatting to the date/time data type control concentrating on the two digit hour time format that doesn’t always show up in two digit form.

Even if you create a custom date/time format within Microsoft Access, the two-digit hour which is supported using the convention of “hh” via the format property doesn’t always work. It will show a single digit hour even though you’ve specified the right code. Take a look at the video below.

httpvh://www.youtube.com/watch?v=rVHwuiezS04

Microsoft Access Tutorial – Working With Two Digit Hour Time Formats

In the video tutorial, it mentioned one of three ways to Continue reading “Microsoft Access Database – Working With Two Digit Hour Time Formats”

How To Create A Running Totals Query In Microsoft Access

How To Create A Running Totals Query In Microsoft Access

If you wanted to calculate a running sum (or a cumulative total) for a report; this is simply set by using the correct ‘Running Sum‘ property for a selected control like a numeric bound field (text box) and all you need to do is decide whether this will be over a group or the whole report.

However, this doesn’t exist in a query and to mimic the report feature to recreate running totals query in Microsoft Access, you will need to be a little creative!

running totals query in microsoft accessEven though MS Access queries you do have a ‘group by’ and ‘where clause’ features where you can choose one of the aggregate functions, there is Continue reading “How To Create A Running Totals Query In Microsoft Access”