Can I Merge 2 Txt Fields To 1 Memo Field

Apr 6, 2006

Hi,

I have an old database for generating service reports which has:
Report No
Date
Customer
Site

In separate fields which is fine

but also

wrk1
wrk2
wrk3
etc.

with a separate field for each printed line on the page
I would like to merge all these into one memo field while retaining the previous data which goes back 15 years (it came from a MSWorks 2.0 DOS db which is the reason for the weird structure I think)

Is there any way to write a macro or code to selectively merge some but not all fields in a table?

I've already copied the db and modified it after clearing all the old data, it works fine but I'd like to have access to the old data in the new format

TIA

Kim

View Replies


ADVERTISEMENT

Merge Fields Into One Field

Aug 14, 2005

I have a table and would like to merge all the fields into one text field of the table after the insert. I'm using adp (access/sql server).

When using standard sql the null values give a problem and i don't want to use the if clause as it will give too much coding.....

View 1 Replies View Related

Queries :: Creating A Query That Will Merge Various Fields Into One Field

Jun 9, 2015

way to merge various fields from a table into just one using a query.The purpose will be for easier copying and pasting in to an email.So we have a table to stores information such as Site Contact, Address 1, Address 2, Address 3, Postcode etc.

I want to be able to run a query that will put the address in to just one box, either in the query or on a report then it's much easier to just highlight the full address and copy and paste it into an email. Rather than copying each field individually.

View 3 Replies View Related

Convert Memo Field To Multiple Text Fields?

Nov 14, 2014

In 2002, I set up a database with Access 97 which included a table with a memo field. Through the years, the database has moved from Windows XP and Access 97 to Windows 7 and Access 2007.
Recently, the memo data has been difficult to edit (the display will move away from the cursor, or a new record will be inserted).

It appears to be logically straightforward to convert the memo data into multiple text fields as the memo field can be parsed for dates of entry.

View 3 Replies View Related

General :: Concatenate Two Text Fields Into A Memo Field In Query?

Sep 5, 2014

I'm trying to concatenate two text fields into a memo field using an expression in a select query. My problem is that the text fields together end up more than 255 characters, so I need the resulting field to be a memo instead. I can't change the underlying text fields to memo fields because this is a large database used by others who need those fields to be text.

View 3 Replies View Related

Tables :: Extract Data From Memo Field And Put Into Separate Fields Of New Table

Jun 15, 2014

I have a notes field in the customer table that is a memo field. An example of one customer's notes field data :

<div>20.3.14 Ordered 2 cartons</div>
<div>4.3.14 Ordered 2 cartons</div>
<div>18.2.14 ordered 1 carton</div>
<div>30.1.14 ordered 3 cartons SCENTED wipes</div>

[Code] ....

I want to extract the date to append to a date field in a "Calls" table and the comment into a text field in the "Calls" table. Is there a way I can do this via query or code?

View 2 Replies View Related

Merge Fields

Apr 1, 2008

How can I merge 4 fields from 1 table into new field which will look like:

field1,firld2,field3,field4 ....

View 3 Replies View Related

Merge One Or More Fields

Oct 3, 2006

Hi,

I want to create an expression in a query, which is a combination of one or more fields in a table. e.g., Concatenate function in excel. Is there any such function in access. Please help me.

Thanks & Regards

View 2 Replies View Related

Merge Fields?

Dec 16, 2007

Howdy, a newbie here, and new to access, but pretty strong computer skills..

need you're help please....

trying to "merge" fields - i think merge is the right name for it...

here's an example of the data...

100 ___
200 200
300 ___
___ 400
500 500
600 ___
___ 700

where the ___ = empty

I need it to look like this, a single field..

100
200
300
400
500
600
700

the values in the two fields are always the same if the exist in both fields..

thanks in advance!!!

Happy Holidays!

View 13 Replies View Related

How Can I Merge 2 Fields ?

Jan 4, 2008

I want to turn this set of fields returned from a query :-

'Stage'-'Engineer'-'BDE'
A-a-e
A-b
B-c-f
C-d

Into this result by merging the fields 'Engineer' and 'BDE' :-

'Stage'-'NewField'
A-a
A-e
A-b
B-c
B-f
C-d

Something like [Engineer]&[BDE] just joins up the text which isn't what I want.
A-ae
A-b
B-cf
C-d

I hope this makes sense.

View 2 Replies View Related

Memo Fields

Aug 15, 2007

Hi All,

This is probably the simplest question to answer but alas I can't find the answer in any of my books!

I have a memo field which when made into the form is for a comments box (therefore has to be a memo box). However, the end user wants to be able to type in the comments and have this is paragraphs but of course the field doesn't want to do it.

I've tried various commands in the properties and also in the formats etc. and now I'm at a loss - can someone please give me some much needed guidance, and I really am sick of looking at this database and would like to get rid of it!

Thanks in advance guys.

Donna :eek:

View 2 Replies View Related

Memo Fields

Jan 18, 2005

How can you use a memo field in a combo box.

How can you edit a memo field used by the combo box once it has been selected in a form.

View 1 Replies View Related

Memo Fields

Nov 2, 2006

I have a memo field in my database, as the data is too long to be a text field. The data in this field has been pasted in from other sources, and somehow it seems to have remembered the original pasted formatting, which was like a newspaper column. So when I include this field on a report, I get a thin column of text, even though the text box on my report is much wider. Is there a way of getting the text from my memo field to wrap to fill the width of my text box, so I get a neat-looking report. Thanks.

View 3 Replies View Related

Query To Merge Fields?

Feb 5, 2007

Hey guys,

I'm in need of some help again. I have two tables, Table1 and Table2. I have one field in each table that I want to have the same data. I don't want blanks to be merged, but I want all the data to be the same

for example

Table1
---------
1

3

5

Table2
---------
1
2

4

6


I would like both tables to be merged to show

Table1
-------
1
2
3
4
5
6

Table2
------
1
2
3
4
5
6

But I want to just update both tables and not create anything new.

Sorry if this is unclear

View 2 Replies View Related

Merge 2 Fields In A Report

Apr 19, 2005

Is there anyway that I can merge two fields together in a report? For example instead of having first name and surname as separate fields I want to put them together so that I don't have a big gap between them. The report is based on a query if that's any help!

View 3 Replies View Related

Merge Two Fields At One In Report

Mar 28, 2013

How to merge two fields at one in report

View 4 Replies View Related

Hyperlinks In Memo Fields

Dec 9, 2007

I have been asked if is possible to highlight some text in a memo field and make it a hypertext link.

A memo field can be changed to a hyperlink field, this is not what is wanted.

View 1 Replies View Related

Compare Memo Fields

Feb 5, 2008

Can someone tell me if this can be done somehow.

I have a date field, ID field and a memo field (I have to have this memo field).
I want to compare the memo fields by two certain dates and find out what doesn't match and if the ID field is blank. I have been trying with quaries but no luck.

I am not sure what forum this would fall under so I put it in general. feel free to move.

View 7 Replies View Related

Should I Avoid Memo Fields

Jul 18, 2005

I've read on this forum that memo fields can be a spot of bother. I only saw this after I put several memo data types in my tables. I wasn't going to do that much with them; it was intended as a electronic scratch pad of sorts for the user. Where does the trouble arise from with them? Should I just leave them or should I change them to text fields with 255 chars and hope that's good enough?

scratch

View 1 Replies View Related

Memo Fields/boxes

Jan 23, 2006

I have a memo field on a form that I only want 800 characters. (text fields don't seen to work). I'm looking for a piece of code that monitors the typing into a memo field and alerts the user that they are overe quota for that field when 800 characters are passed.

Any ideas are appreciated.

View 3 Replies View Related

Querying Memo Fields

Mar 22, 2007

Hello There,

I wonder if someone can clear up a problem I am having. We have a system under development which is heavily dependent on an existing MS Access database. Some of the queries in the Access version of the application query Memo fields and they work fine within Access.

If I try to use exactly the same query from an ASP/Vbscript web page the query does not return the expected results. I am using ADO and an ODBC DSN connection, all of the other queries seem to work fine.

I have a vague recollection of being told that you can not query Memo fields through an ODBC DSN, or that not all of the Memo field is queried, only the first 255 characters. Can anyone confirm this is true. I have tried searching the web, and some references that I have available, but it seems that there is nothing out there to confirm my suspicions.

Any direction anyone could give me would be hugely appreciated.

Thanks in advance.

View 4 Replies View Related

Export To Excel And Merge Fields

Aug 5, 2005

Hello folks

I am developing a basic Fault Logging system so I have a main form that allows ref to be input, date fault raised, priority, etc... I also have a sub form running that allows notes to be input. There is no set limit on the number of notes that can be added as this needs to be flexible. A relationship is set up so that the Fault reference will be tagged to each of the notes. What I need is a query (I'm guessing that is the best way to do it) that will gather all of the standard fields fromthe main form and also all of the note fields (it will need to return null values in notes fields). Preferably I would like all of the notes fields to concatenate into one field with a line break between each note. The concatenation process would have to be flexible and dynamic as there is no predetermined limit to the number of notes that will have to be joined together.

I'm relatively new to Access and having searched the forums and tried a few ideas can't find anything that I can adapt to my situation. Any ideas/guidance would be greatly appreciated!

Thanks!

View 3 Replies View Related

Auto Expand Memo Fields

Apr 19, 2006

I'm working on a sub-form set to continuous and would like to amend a memo filed so that it autoexpands when entered. Have tried amending the height of the field through the on enter an on exit functions but this alters the size of the form.

Any clues would be much appreciated.

Fozi

View 1 Replies View Related

Memo Fields - Order Of Data

Dec 6, 2007

Hello people.

Im just after a bit of advice please??

I have created an audit trail for data held on a form so that when a field is changed it adds a line of text to a memo field with the date of the change and the old and new field values. The problem I have is that each time something is changed the line of text is added beneath the existing text in the memo field. This means that for users to view the most recent change they have to scroll all the way down to the bottom of the memo field. Is there a "Quick" way of me having the most recent entry first.
I am using the vbnewline command when adding the text. A sample is shown below:

Dim Response As Integer
Dim AnotherItem As Integer
Dim sqlstr As String

Set Myform = Forms![DataDetail]
Producer = Forms![ListOfProducers(Existing Data Item)]![LstProducers].Column(1)

Response = MsgBox("Are you sure you wish to add a Producer?", vbYesNo, "Data Dictionary v1.0")
sqlstr = "INSERT INTO DataProducers ( Data_Id, Producer_Id ) SELECT Data.Data_Id, Producers.Producer_Id FROM Data, Producers WHERE (((Data.Data_Id)=[Forms]![DataDetail]![Data_ID]) AND ((Producers.Producer_Id)=[Forms]![ListOfProducers(Existing Data Item)]![LstProducers]));"
If Response = 6 Then
DoCmd.RunSQL sqlstr
Myform!LstHistory = Myform!LstHistory & vbNewLine & "Changes made on " & Now & ""
Myform!LstHistory = Myform!LstHistory & vbNewLine & "The Producer '" & Producer & "' was added to this data item"""
Myform!LstHistory = Myform!LstHistory & vbNewLine & "-----------------------------------------------------"
MsgBox "Producer has been successfully added.", vbInformation, "Data Dictionary v1.0"


Thanks folks...

View 2 Replies View Related

Unable To Sort Memo Fields?

Mar 16, 2006

A quick question... is it possible to sort a table by a memo field? I have a table and am able to sort by other, non-memo fields, however when I place my cursor in the memo fielld I would like to sort, the sorting option becomes 'greyed-out'. Is there a way around this?

View 7 Replies View Related

Memo Fields Mess Up My Database

Aug 8, 2007

Hello,

when I update a form with a new record, that record will copy to any previous record that I click in the same form.

This only happens when I'm adding records to a table that contains a memo field...

Anything I need to keep in mind about memo fields?

Kind regards,
Hans B.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved