Hi guys,
My table has a memo field. At the end of the month a run
a report and I would like to concatenate the memo fields in a unique
field by
dept. Im thinking doing this through totals button , but in the
combobox
there are only max,min,sum,.. There is no concatenate function.
Im avoinding doing that using VBA.
Somebody help me please.
Maffonso 7 2666
You are going to have to do _something_ more than wish for a simple macro
solution.
Just offhand, using VBA in the OnPrint event of Detail records, to
concatenate ("&" is the concatenation operator, with "+" also working if
there are no Null Memo Fields) is the simplest approach, and then moving the
contents of the variable where you concatenated into a Text Box in the
OnPrint event of the Group Footer for the department.
Larry Linson
Microsoft Access MVP
"maffonso" <mm*******@gmail.com> wrote in message
news:11**********************@i40g2000cwc.googlegr oups.com... Hi guys, My table has a memo field. At the end of the month a run a report and I would like to concatenate the memo fields in a unique field by dept. Im thinking doing this through totals button , but in the combobox there are only max,min,sum,.. There is no concatenate function. Im avoinding doing that using VBA.
Somebody help me please. Maffonso
Just for starters, it sounds like you really are trying to group on Memo
fields. You can't.
You can concatenate; you can extract some number of characters from the left,
middle, or right; you can even move every word in the memo field to an array
in one line of code. But you can't group on Memo fields.
Can you say a bit more about what you're trying to accomplish? Memo fields
are for holding large amounts of text. (Limit=32K characters). There is
nothing you would normally put in a Memo field that would merit or encourage
grouping.
On 5/26/2006 2:10:10 PM, "maffonso" wrote: Hi guys, My table has a memo field. At the end of the month a run a report and I would like to concatenate the memo fields in a unique field by dept. Im thinking doing this through totals button , but in the combobox there are only max,min,sum,.. There is no concatenate function. Im avoinding doing that using VBA.
Somebody help me please. Maffonso
--
Science is organized common sense where many a beautiful theory is killed by an ugly fact (Thomas Huxley).
Hi guys,
My table is month,dept, comment.
A have to do a report by dept , doesnt matter month.
Most of the comments are about 400 characters (that discards text
field).
First question: Are there a type between text and memo?
Pehaps I could use textfield and limit the lenght of the comment to 255
but users could complain.My boss would love it.
Larry, could you explain better how to concatenate the memos using &.
Like this: txtComment = txtComent & memoField ?? Is that Ok?
Thank you all.
"maffonso" <mm*******@gmail.com> wrote in
news:11**********************@u72g2000cwu.googlegr oups.com: Hi guys, My table is month,dept, comment. A have to do a report by dept , doesnt matter month. Most of the comments are about 400 characters (that discards text field). First question: Are there a type between text and memo? Pehaps I could use textfield and limit the lenght of the comment to 255 but users could complain.My boss would love it. Larry, could you explain better how to concatenate the memos using &. Like this: txtComment = txtComent & memoField ?? Is that Ok?
Thank you all.
Insead of trying to concatenate the memo fields, build your
report using the summary query, and add a subreport that
contains only the memo fields for the department and a hidden
field that contains the department name..
--
Bob Quintal
PA is y I've altered my email address.
"maffonso" <mm*******@gmail.com> wrote Larry, could you explain better how to concatenate the memos using &. Like this: txtComment = txtComent & memoField ?? Is that Ok?
That would depend on where you were doing the concatenation and the details
of the situation.
Dim strSomeComment as String
Dim strSomeMemo as String
. . .
strSomeComment = strSomeComment & strSomeMemo
would be OK. If the memo data to be concatenated is in a Field in a Record
read with DAO or ADO, or if it is in a Control displayed on a Form, or if it
is a Field in the Form's RecordSource but not displayed in a Control, then
the notation would be different.
Larry Linson
Microsoft Access MVP
"Larry Linson" <bo*****@localhost.not> wrote in
news:E2leg.2639$As2.1511@trnddc02: "maffonso" <mm*******@gmail.com> wrote
Larry, could you explain better how to concatenate the memos using &. Like this: txtComment = txtComent & memoField ?? Is that Ok?
That would depend on where you were doing the concatenation and the details of the situation.
Dim strSomeComment as String Dim strSomeMemo as String . . . strSomeComment = strSomeComment & strSomeMemo
would be OK. If the memo data to be concatenated is in a Field in a Record read with DAO or ADO, or if it is in a Control displayed on a Form, or if it is a Field in the Form's RecordSource but not displayed in a Control, then the notation would be different.
But then you might run into the DAO memo concatenation problem,
which causes the result to be gibberish atfer the 255th character.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
I still don't see what you're need to concatenate.
If you have a field that denotes the Dept, you can restrict data by that
field and print all the records for a single department (showing all months)
or for a single month (showing all departments) or any combination.
Is it maybe enough just to restrict what you're printing, and then you don't
actually have to concatenate these memo fields? This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Jeremy |
last post by:
I have a pretty straightforward database that is designed to record
free-form information about products (date, source and a memo field).
This is searched and updated via a form. For new records,...
|
by: Remco Groot Beumer |
last post by:
Hello,
In an Access 97 database, there is a table that has some Memo-fields. Some
of the memo-fields (not all) with a lot of text in it, display the data
blurred all over each other (two...
|
by: ken |
last post by:
I have 5 memo fields in one of my tables. I need to add 7 more. Will
this be a problem? Am I being paranoid?
Thanks
|
by: jacoballen |
last post by:
I have a query that combines the results of three related tables. The
memo fields are truncated to 255 characters, but I need all the
information in them. I'm aware that removing code such as...
|
by: RMC |
last post by:
Hello,
I'm looking for a way to parse/format a memo field within a report.
The Access 2000 database (application) has an equipment table that
holds a memo field. Within the report, the memo...
|
by: kaplan.gillian |
last post by:
Hi everyone,
I currently have an Access database that includes quite a few
long memo fields. When I create a report of my data, Access
does not allow the memo fields to be split with the page...
|
by: ARC |
last post by:
This is mainly a speed question.
In this example: I have a QuotesHdr table that has a few memo fields. If
these memo fields are used extensively by some users, and if their are a
large number of...
|
by: steph |
last post by:
I have a table with 250 fields. Of course you are wondering why 250
fields... what could I possibly be storing in so many fields?
I am using this table as a general import table for files that...
|
by: Wayne |
last post by:
I've been asked to construct a database which will require several
memo fields. This database will be the standard frontend/backend mdb
configuration. I have read many posts describing the...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
| |