K
Kerry H
Blimey - I am sooo stuck. I am afraid that I will have to
explain my predicament in detail. Here goes.......
I have 2 sheets storing shares bought and shares sold
(each sheet has around 12,000 records)
I need to extract information for clients on their losses
for shares traded after 1st August 2001.
I have created an advanced filter which does this fine and
put the resuting records onto a new sheet.
i have 1 answer sheet with all the answers, 1 anwer sheet
with just the bought answers and a 3rd answer sheet with
just the sold answers as i can't work out how best to
manipulate them.
Now for the tricky bit...
Number 1
If a client number and share id number in the bought data
matches with a client number and share id number in the
sold data i need to know the difference (bought - sold)
The client may have bought many many shares on different
occasions e.g. i need to know that they hold 1000 shares
in abc ltd even if they bought these shares in 100
separate purchases on seperate days. (tried groups and
totals and it just doesn't work)
They may also sell the shares in stages too a client may
have sold 500 shares but at 100 per month
Number 2
A client may have bought and not sold in which case i need
to know what they have left
Number 3
A client may have sold shares but not bought (this means
that they did not buy though us) so I don't want to know
about them.
Number 4
A client may have sold more shares than they have bought
because they bought extras through another stockbroker in
which case i don't want to know any information about them
I think that is everything... ha ha nervous laugh..
It sounds easy enough when explaining it but i just cannot
get my head around where to start. would it be better to
put the answers into Access an interrogate them from
there??
Thank you very much for reading all my blurb and thanking
you in anticipation of some help.
Kerry.
explain my predicament in detail. Here goes.......
I have 2 sheets storing shares bought and shares sold
(each sheet has around 12,000 records)
I need to extract information for clients on their losses
for shares traded after 1st August 2001.
I have created an advanced filter which does this fine and
put the resuting records onto a new sheet.
i have 1 answer sheet with all the answers, 1 anwer sheet
with just the bought answers and a 3rd answer sheet with
just the sold answers as i can't work out how best to
manipulate them.
Now for the tricky bit...
Number 1
If a client number and share id number in the bought data
matches with a client number and share id number in the
sold data i need to know the difference (bought - sold)
The client may have bought many many shares on different
occasions e.g. i need to know that they hold 1000 shares
in abc ltd even if they bought these shares in 100
separate purchases on seperate days. (tried groups and
totals and it just doesn't work)
They may also sell the shares in stages too a client may
have sold 500 shares but at 100 per month
Number 2
A client may have bought and not sold in which case i need
to know what they have left
Number 3
A client may have sold shares but not bought (this means
that they did not buy though us) so I don't want to know
about them.
Number 4
A client may have sold more shares than they have bought
because they bought extras through another stockbroker in
which case i don't want to know any information about them
I think that is everything... ha ha nervous laugh..
It sounds easy enough when explaining it but i just cannot
get my head around where to start. would it be better to
put the answers into Access an interrogate them from
there??
Thank you very much for reading all my blurb and thanking
you in anticipation of some help.
Kerry.