misslee1888
New member
- Local time
- Today, 19:55
- Joined
- Dec 2, 2002
- Messages
- 98
I have a query for which I am trying to get the min date of the record in my subform.
I have done this and mamager to get the total for some of my other fields using:
Forms!frmSoftwareLicenseEntry1.TOTCOST = DSum("[TOTAL]", "QUERyCALC", "[QUERYCALC.SOFTWAREID] = " & [SoftwareID])
I have created a query called Querycalcinv
But I just can seem to get the syntax right. I have tried
Forms!frmSoftwareLicenseEntry1.nextdate = Min("[NEXTDATE]", "QUERyCALCINV", "[QUERYCALCINV.SOFTWAREID] = " & [SoftwareID])
but it doesnt seem to like it. Can anyone give me some assistance.
I have been at this for ages.
I have done this and mamager to get the total for some of my other fields using:
Forms!frmSoftwareLicenseEntry1.TOTCOST = DSum("[TOTAL]", "QUERyCALC", "[QUERYCALC.SOFTWAREID] = " & [SoftwareID])
I have created a query called Querycalcinv
But I just can seem to get the syntax right. I have tried
Forms!frmSoftwareLicenseEntry1.nextdate = Min("[NEXTDATE]", "QUERyCALCINV", "[QUERYCALCINV.SOFTWAREID] = " & [SoftwareID])
but it doesnt seem to like it. Can anyone give me some assistance.
I have been at this for ages.