Why do you have the product information in the footer when you already have in the Combo form? You can show everything when you do the report.  John

Not sure what you are asking but putting the info in the order form notes is what puts that info on the invoice. The photo is three different components, Timesheet, Order Form and a segment of the Invoice.

Hi Julian, The Invoice has a date and an Invoice Number. The InvoiceDetail contains all the items on that invoice. When you create a query which contain all the information about the Invoice and Invoice details you have the makings of a report or (Invoice). It seems that should be the approach one should take. The only information in the InvoiceDetail footer might be totals. HTH John

Show us the code you're using for the Form Totals that's not working.

-Raymond

I am using basic math in the query for the form. They are in order as presented.

TotalMinutes: DateDiff('n',[StartTime],[EndTime])
HoursWorked: Round([TotalMinutes]/60,2)
WholeHoursWorked: Int([HoursWorked])
MinutesLeft: [TotalMinutes]-([WholeHoursWorked]*60
Duration: [WholeHoursWorked] & ":" & Format([MinutesLeft],"00")

The above is working because the totals are correct when they show up either after closing and reopening the timesheet form or if I click the Create Invoice button and go back to the timesheet form the footer totals show up. Shouldn't they show after putting in date/times which creates the minutesworked total and the hours worked totals. See Timesheet Form above.

Are you using any VBA or Macros with your forms? Essentially, if the footer totals are being generated in the query, you need to force a requery of the data after a record is updated/inserted.

Likewise, for your notes field, where is the information populating that coming from, if it's from your query, then it should populate with the requery.

Donald Good idea. In thinking more about it the footer totals are setup up to add two or more hours worked entries so a single entry probably won't populate the footer totals. There should be a way to show a single entry footer total though. I tried the requery but it didn't change results. And above mentioning it may be the fact of a single entry, well I just tried adding a second entry and the footer totals are still blank.

Hmm, have you tried taking the Duration off of that query. Then create a new query with that one's * as it's main field then create the Duration field in the new query, maybe Access just can't do the calculations all at once. Sometimes a query will struggle to sum up a formula based on values calculated in that query. Hope that makes sense.

I have realized that the footer total fields stay blank no matter how many date/times you enter. The only way you can get them to show totals is if you close the form and reopen it.

I would need to see your actual query in design view to understand what is happening.

I suspect it is because once the form has loaded, query has already run and calculated the total. By closing and reopening, it forces a complete requery of all records instead of just the current row. The reason you get blank after entering a row and moving to the next record is because there is no data in the "New Record" row, but if you click back onto a row that has data, it might at least show the totals for that row in the footer, but not sure.

Again, perhaps show your query expanded in design view as well as your form so that we could figure out what is going on.

In getting some suggestions I started studying info on requery and recalc. I tried requery and could get nothing to work. Looking back it may have had something to do with not putting it on all fields, not sure. I started working with recalc and the info said I just needed to place Me.Recalc in update event on the TotalMinutes and Duration Fields, upper line detail. I tried and it didn't work so I placed a recalc in all fields, detail and footer, that had to do with numbers and totals and still didn't work. Then it dawned on me that date/time are numbers so I placed recalc in StartTime and EndTime. It now works! I actually believe that as I tab over to TM and Duration the footer totals show up first. In looking back I may have been able to only add recalc to Start/EndTime, TotalMinutes and Duration but hey, it works and I am getting no compile errors.

Just an update in case anyone is reading or this can help. Turns out that having Me.Recalc in every field that had to do with numbers and totals did create problems. However, it works fine with just having Me.Recalc in StartTime, EndTime, TotalMinutes and Duration. In other words all the detail number fields.