M
Mellissa via AccessMonster.com
Hello,
My name is Mellissa and I was wondering if anyone can help me with something?
Currently, in my table I have 3 notes columns:
-Insurance Notes
-Fund Company Seg Notes
-And Mutual Fund Notes
However, when I create a query to pull ALL notes under one Advisor in
datasheet view, I do not want three seperate columns which is currenty what I
am getting.
I tried only having one notes column However...
On my main Form, I have a subform with two tabs and if I enter a note in the
"Insurance" tab and then go to the "Fund Company Seg" tab, then the same note
from "Insurance" appears.
Is there any way that on the FORM view, if I enter a note in the "Insurance"
tab, that same note will NOT appear in the "Fund Company SEG" tab??? BUT the
notes will somehow amalgamate together OR will appear under the same data
information but on a seperate row???
Am I making sense?? LOL
Or is it simply better to have the seperate fields? If so, is there any way
for me to resolve this in a query?
Thank you soooooooo much!!!!
Mellissa
My name is Mellissa and I was wondering if anyone can help me with something?
Currently, in my table I have 3 notes columns:
-Insurance Notes
-Fund Company Seg Notes
-And Mutual Fund Notes
However, when I create a query to pull ALL notes under one Advisor in
datasheet view, I do not want three seperate columns which is currenty what I
am getting.
I tried only having one notes column However...
On my main Form, I have a subform with two tabs and if I enter a note in the
"Insurance" tab and then go to the "Fund Company Seg" tab, then the same note
from "Insurance" appears.
Is there any way that on the FORM view, if I enter a note in the "Insurance"
tab, that same note will NOT appear in the "Fund Company SEG" tab??? BUT the
notes will somehow amalgamate together OR will appear under the same data
information but on a seperate row???
Am I making sense?? LOL
Or is it simply better to have the seperate fields? If so, is there any way
for me to resolve this in a query?
Thank you soooooooo much!!!!
Mellissa