Show Records of current user only
- Thread starter Moore71
- Start date
That doesn't make much sense. DSum is an aggregate function, (meaning one value), but you said you want to display 'records' plural.
Can you better describe what you want (possibly using sample data) and also what you have tried to accomplish that?
What i mean is that i have 2 or users that are entering some figures into a table.
There is a textbox that display the sum of their entries.
So what i want is how that textbox can sum only records of on current user, maybe using user ID as criteria to fetch the records and sum them. That's all
There is a textbox that display the sum of their entries.
So what i want is how that textbox can sum only records of on current user, maybe using user ID as criteria to fetch the records and sum them. That's all
I haven't tried anything really because I don't know how to insert the criteria [WHERE UserID=field1 of table A] or something like that
Maybe I should better use subform to display records from current user binding subform to mainform, if this cannot work
Maybe I should better use subform to display records from current user binding subform to mainform, if this cannot work
Here's the documentation for the DSum function: http://www.techonthenet.com/access/functions/domain/dsum.php
It definitely won't work if you never try it.
It definitely won't work if you never try it.
- Local time
- Today, 10:18
- Joined
- Sep 12, 2006
- Messages
- 16,121
It's all doable, but it can be a pain.
the difficulty with this sort of stuff, is that you have to include some appropriate data in the table (or query) enteredby, amendedby, or similar - and then you have to write an interface to select and manage the data selections.
It's the same if you want a system where different users see information for selected depots, say.
You therefore have to build this selection functionality into every form/report where it is needed. It doesn't come with databases by default.
the difficulty with this sort of stuff, is that you have to include some appropriate data in the table (or query) enteredby, amendedby, or similar - and then you have to write an interface to select and manage the data selections.
It's the same if you want a system where different users see information for selected depots, say.
You therefore have to build this selection functionality into every form/report where it is needed. It doesn't come with databases by default.
Similar threads
