R
Rich
Guest
I want to sum a field on a form, but only where the KeyID is unique. I don't really want to use DLookup on a query. Any ideas?
Robert Dunstan
Mr Data
- Local time
- Today, 00:17
- Joined
- Jun 22, 2000
- Messages
- 291
Rich,
Just a thought, but would the IIF function do?
Just a thought, but would the IIF function do?
R
Rich
Guest
Thanks for the suggestion Rob, but unless I'm brain dead, (quite feasable at the minute,I know
), there's no way to construct this using an Iif, ' least that I can think of
), there's no way to construct this using an Iif, ' least that I can think of
Robert Dunstan
Mr Data
- Local time
- Today, 00:17
- Joined
- Jun 22, 2000
- Messages
- 291
Rich
On your form are you showing multiple records (continuos view) or just plain form view? As another suggestion, in the On_Current event or whatever is applicable could you not count the number of times KeyID appears and if the count =1 then perform your calculation else return a zero etc.
On your form are you showing multiple records (continuos view) or just plain form view? As another suggestion, in the On_Current event or whatever is applicable could you not count the number of times KeyID appears and if the count =1 then perform your calculation else return a zero etc.
R
Rich
Guest
It's a datasheet, the problem is that say for one invoice there may be several payments listed, on the form there are also several invoices, I just need to display the Sum of the invoices issued. I suspect the only way is with vba.
