Search results

Thank You! Created a sub-query just totalling the invoices and added the insurance formula and that worked! 😃 As always...this forum is a great help!

The TotalSum in the invoice actually comes from a table named tblTaskSheetDtls. Once a task is completed the task number is added to the invoice from a combo box. The query qryTaskSheetDtls calculates the TotalSum, the code for which is: Nz(IIf(([External]=Yes) And...

Here is the code: Sum(IIf([TotalSum]<21,[TotalSum]*0,IIf([TotalSum]>=4820,4820*0.171,[TotalSum]*0.171))) If the invoice is less than $21 then insurance is not charged; if it is greater than and equal to $4820, insurance is only paid on $4820. Even though the TotalSum of the invoice is correct...

Good Morning, I have a query that calculates the insurance on the sum of an invoice. I have two invoices - the first one consisted of 3 items totalling $75.00 (30+30+15); the second one was 1 item totalling $75.00. The insurance is 17.1%. For the first invoice the calculation returned a...

Thank you so much. That works! Really appreciate both your and theDBGuy's help. If it's ok I will delete the db from the forum as some of the info is not sample data. I'll just wait a bit for theDBGuy to see your solution and then delete. Again...THANK YOU!

Please see attached db. The most important form is the frmTaskSheet as this is what I use to generate invoices. Looking forward to your feedback

Unfortunately I don't have winzip. Is there another way I can share the db with you?

The forms are as follows: -frmClients linked to subform frmJobs by the ClientID field -frmTaskSheet linked to subform frmTaskSheetDtls by the TaskID field -frmTaskSheet linked frmClients by ClientID field Each Client has a Task sheet e.g. ClientID #1 tasks are entered in TaskSheet #1 I just...

To the specific client only

Hi. I'll give some more detail. The form frmClients includes the subform frmJobDetails which is linked to the frmClients by the ClientID. In frmJobDetails I list the job name and a brief description of the type of project Each client has a task sheet. The subform frmTaskSheetDtls has the...

Thank you but I don't understand exactly where I would enter this command. Is there a particular event for the cboJobName I should enter this under?

Hello, I have a client task sheet form with a combo box cboJobName that lists all the jobs for that specific client. I have the List Items Edit Form property set to frmClients (which includes the subform frmJobs). How can I open the frmClients to the Client whose task sheet I am working in...

Thank you all for your help. For the first formula I took out the IIF part and that worked. For the second one, I split the formula into two separate calculated controls and then totalled those two. No #type! or #Error messages. Thanks again :D I might have another query later on ;)

Hi, Adding Nz didn't work and both fields are in the form only, not in the tables. I tried setting the Default Values in the form properties to 0 but that didn't work

Hello, I have two slightly annoying issues. I have a DLookup formula on my data sheet subform that is working, however, in the next blank record, that field has an #Error message which is a little irritating to see. But when I key in data the #Error goes away. Below is the formula...

Thank you. The first formula - =((DateDiff(“n”,[StartTime],[EndTime])+7.5)\15)/4 - works best for me. Thank you so much for your help! :)

Thank you

Yes...I'm confusing myself now!

I just received an email from the owner of the database who advised they gave me wrong information which I, unfortunately, passed on to this forum. Please accept my sincerest apologies. The original formula =DateDiff("n",[StartTime],[EndTime])/60 is returning figures like 8.17 or 6.80. They...

Hi, So these are some of the variations of the formulas I have tried...I think I am typing it incorrectly because every formula except 1 is returning the #Name? =DateDiffMinutes("n",[StartTime],[EndTime]/60)/4 = #Name? =DateDiffMinutes([StartTime],[EndTime]/60)/4 = #Name...