Geoff Codd
Registered User.
- Local time
- Today, 04:11
- Joined
- Mar 6, 2002
- Messages
- 190
I've inserted the following into my query now it won't work, and comes up with the error "Microsoft can not find the name 'Present Date' you entered in your expression
DMax("[Cost_Per_Unit]","[Invoice Recharging (External) Costs]","[Company] = [Forms]![Invoice Recharging (External) Invoice Creation]![Company] And [Utility_Type] = [Forms]![Invoice Recharging (External) Invoice Creation]![Utility_Type] And [Effective_Date]<=[Present Date]") AS [Price_Per _Unit]
Any idea's are appreciated
Thanks
Geoff
DMax("[Cost_Per_Unit]","[Invoice Recharging (External) Costs]","[Company] = [Forms]![Invoice Recharging (External) Invoice Creation]![Company] And [Utility_Type] = [Forms]![Invoice Recharging (External) Invoice Creation]![Utility_Type] And [Effective_Date]<=[Present Date]") AS [Price_Per _Unit]
Any idea's are appreciated
Thanks
Geoff