SubForms - Similar Fields????

[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

 

[Guest]

You can concatenate the three note fields like this --
[Insurance Notes] & " " & [Fund Company Seg Notes] & " " & [Mutual Fund
Notes]

OR like this --
[Insurance Notes] & Chr(13) & Chr(10) & [Fund Company Seg Notes] &
Chr(13) & Chr(10) & [Mutual Fund Notes]

 

[Mellissa via AccessMonster.com]

Hi,

Where would I put this concatenate equation? Would I enter it in the Query
level under SQL view?

Mellissa

You can concatenate the three note fields like this --
[Insurance Notes] & " " & [Fund Company Seg Notes] & " " & [Mutual Fund
Notes]

OR like this --
[Insurance Notes] & Chr(13) & Chr(10) & [Fund Company Seg Notes] &
Chr(13) & Chr(10) & [Mutual Fund Notes]

Hello,

[quoted text clipped - 29 lines]

Mellissa

 

[Guest]

SELECT Xxxx, Yyyyy, [Insurance Notes] & " " & [Fund Company Seg Notes] & "
" & [Mutual Fund Notes] AS Notes, Zzzzz

--
KARL DEWEY
Build a little - Test a little

Hi,

Where would I put this concatenate equation? Would I enter it in the Query
level under SQL view?

Mellissa

You can concatenate the three note fields like this --
[Insurance Notes] & " " & [Fund Company Seg Notes] & " " & [Mutual Fund
Notes]

OR like this --
[Insurance Notes] & Chr(13) & Chr(10) & [Fund Company Seg Notes] &
Chr(13) & Chr(10) & [Mutual Fund Notes]

Hello,

[quoted text clipped - 29 lines]

Mellissa