Reputation: 104 Stalwart
- Expert w/DIC++
- Active Posts:
- 904 (0.41 per day)
- 09-December 08
- Profile Views:
- Last Active:
- Jan 24 2013 01:07 AM
- OS Preference:
- Favorite Browser:
- Internet Explorer
- Favorite Processor:
- Favorite Gaming Platform:
- Who Cares
- Your Car:
- Dream Kudos:
- Expert In:
Posts I've Made
Posted 19 Dec 2012That does look like should work, although I would put the lower criteria before the higher.
Provide the complete SQL statement.
You don't want the results to be inclusive for the criteria?
Posted 17 Dec 2012Concatenate variables. Reference to the current record ID is a variable:
Ltotal = DSum("Donationpaid", "Donationinfo", "ClientID = " & [clientid])
Posted 29 Nov 2012This is why saving aggregate data is problemmatic. Ideally, save raw data and calculate aggregate data when needed.
Use the BeforeUpdate event of the quantity textbox. Data controls have OldValue and Value properties. So something like:
If Me.control.OldValue & "" <> Me.control.Value & "" Then
'code to modify the inventory record
Need more code in the BeforeUpdate event of Product.
Need more code if record is deleted.
- Member Title:
- D.I.C Addict
- 60 years old
- December 13, 1953
- Anchorage, Alaska
- snowboarding, baseball umpire
- Years Programming:
- Programming Languages:
- VBA, VB, VB.Net, SQL, Fortran
- Website URL: