Search results

I don't think I can. I'm just trying to find the total between the two dates. The information is coming from a query which uses a table called tblJournalEntries. The banking details changed on January 1, 2020 so rather than doing a new db I added the date criteria >2019-12-31. I wonder if...

I realised I made an error by referencing the wrong query. I have corrected that and now instead of no result I am getting #Error. Below is the formula with the correct query name. =DSum("[Amount]","qryAccountLedger2","[TransactionDate] > #2019-12-31# and [TransactionDate]<#" &...

Hi, The result is still blank :(

Good morning, I am trying to sum the amount after December 31, 2019 and a date selected on a form. I am not getting an error message, the result is just blank. =DSum("[Amount]","qryStatement2","[TransactionDate] > #31-12-19# and [TransactionDate]<#" & [txtLastStatement] & "# AND...

Yes...I had to go back and add the apostrophe. Don't know why it worked either but it did 🤷‍♀️

Success. I did the following on the Before Update event and it worked! Private Sub Form_BeforeUpdate(Cancel As Integer) this is a dummy procedure as a test End Sub As always...thanks for everyones help :)

I really wish I could but unfortunately I can't upload the database as it has been in use for 3 years and has some sensitive info in it.

I already have an event in the On Load on my main form :(

Good Morning, I changed an existing form to a tabbed form so I could add a second subform. This is causing an error when I first open the form which says "The expression On Current you entered as the event property setting produced the following error: Return without GoSub". The only On...

Thank you! That worked perfectly!

Good morning, I am using Dmax to create a unique sequential numbering in a form. I would like the first entry to start at 1, however it keeps starting at 0. I tried changing the default value in the table design to 1, but it keeps going back to zero. I put the below code in the forms Before...

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