Recent content by QMDirk

If by default, Access stores the date along with the time, in a field formatted as Short Time, then yes. Otherwise, I've done nothing to deliberately cause the date to be stored with the time. also, I realized earlier that when I tested this, I just typed in the 2 time values. Would it make a...

If I use: =Format([Time Down]-1-[Time Restart],"Short Time") to show the total minutes that have passed, even though it displays the value in terms of hh:mm, how do I Sum the field to show the total of all entries? When I used: =DateDiff("n",[Time Restart],[Time Down])*-1 I just surrounded it...

It shows the minutes correctly but drops the hour value. And 08:00 to 10:00 displays as 0 instead of 120.

I have a form that tracks when the production line stops, and when it is restarted. A 3rd (calculated) field displays the difference. a 4th field Sums up all the downtime and displays the total in the footer. Everything was working fine, until I noticed that if the line stops before midnight...

Hey bro. Here's a method I use and it's pretty easy to keep track of. Create a query on the table that holds the data that is entered when the quote data is entered. In the Criteria field, type: [Forms]![Form 1 name]![ID] - this will look only for the record number indicated by whatever...

This should be easier, but I'm in a panic and under pressure (lol). I have a form with a subform. The user will enter a number on the subform and I want to compare the User's entry with a number on the main form. If it matters, the number on the main form is displayed using the DLookUp function...

This should be easier, but I'm in a panic and under pressure (lol). I have a form with a subform. The user will enter a number on the subform and I want to compare the User's entry with a number on the main form. If it matters, the number on the main form is displayed using the DLookUp function...

Can Access send a Report automatically, at a specific time each day?

Hey everyone. I think this is the right forum for this question. I have a form that tracks Production Downtime. The table contains the fields: [Total Minutes], [Time Down], and [Time Restart]. A form uses the function: =Sum(DateDiff("n",[Time Restart],[Time Down])*-1) to show the difference...

sorry for posting in the wrong forum, I try to be more aware of that. I think you're right though, because when I just run the report, it shows just the 2 entries from the table. But I have a button setup to run the report for the specified record, attach it to an email, and send it to the...

I have a report whose Source = 2 tables in a query where they share a common field: "Order Number". There is a 3rd table that adds the package size information. The Report is set up shows the product that is being ordered at the bottom and a third table shows the shipping dimensions of the...

Can you show the Sum of the values in a calculated field?

I see. To this day, I have never successfully used a Function in VBA to do anything. Web pages don't answer all of my questions and I'm left hanging. I understand what the function is trying to do, I just have no idea where to put it.

Yes, but where, please? The last explaination wasn't clear about where to insert the DateDiff() code...

Hi again. Does anyone have a simple code to subtract one Time from another and display the result in Minutes? Ex: [Time Up]-[Time Down]=[Total Minutes]