filtering question

[Eric Johnson]

New situation:

What I'm working on is creating a call log form that shows static
information on the top part of the form (user id, name, phone, etc) and at
the bottom is a sub form where tracking the times each user has been called
and their eventual answer. simple enough and I have that much worked out
now. Each user in question has a number of network shares that we are trying
to get confirmed by the user.

Several users have multiple shares, I need to generate a query that will
give me a list of users and all the shares they own. I only want the userid
listed once however in the tables I have each share is listed with a userid.
I don't know how to filter things out so that I get one ID and all the shares
with it.

Is this even possible?

 

[Al Campagna]

Eric,
Not sure if I understand... but...
I think your looking for a Totals query.
Bring in your Users table (the One), link it to your ShareActivity (the Many).
Select View/Totals, and GroupBy UserID and Sum on Shares.
Select query...
UserID Shares Date(<<Drop this field from a select query)
123 10 1/1/07
123 -6 1/18/07
123 10 1/24/07

With Totals query...
UserID Shares
GroupBy Sum
123 14
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[Eric Johnson]

What I'm looking for is something similar to this

ID sharename...

I want something that will show the user id once and then list the shares
they own not the number of but the share names

 

[Al Campagna]

Eric,
When a responder doesn't know any of your field names, examples have to be used. I
assumed Share Activity meant sales and purchases.
It's the same concept though...
Better to name your ID field something a bit more meaningful... like ShareholderID or
ClientID...
Totals query....
ID ShareName
GroupBy GroupBy

should yield...
123 Intel
123 IBM
123 Zerox
123 ABC
etc...etc.....

On the report.... Group by ID and ShareName (ascending)
-------------------------------------
ID Header
123
-------------------------------------
Detail Section
ABC
IBM
Intel
Zerox
-----------------------------------
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."