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.....
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
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.
How can I merge 4 fields from 1 table into new field which will look like:
field1,firld2,field3,field4 ....
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
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!
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.
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
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 RelatedHow to merge two fields at one in report
View 4 Replies View RelatedHello 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!
I think the title describes best what I want to do. I need to send a letter to some lets say receivers, who fulfill certain criteria, and who appear in a data field in an access database. The letter is common for everyone with the difference of course of their address and name. I am sure this is an easy one for the most of you....
Thanx in advance, Kyriakos
p.s. sorry for misspelling some words...
I am currently creating a database for lift inspections. The output is a mail-merge report. What I am trying to do is get the multiple Lift Name (child) and Floors Served (child) combined into a string so that each Lift Group (parent) inspection has only one row. This then means that each lift group inspection will be shown as one record in mail merge.
Current
Lift Group ID - Date of Inspection - Lift Name - Floors Served
34 - 14/01/14 - Lift 1 - G-1
34 - 14/01/14 - Lift 2 - 1-3
35 - 14/01/14 - Lift 3 - G-8
34 - 14/01/13 - Lift 1 - G-1
34 - 10/10/13 - Lift 2 - 1-3
Desired:
Lift Group ID - Date of Inspection - Floors Served
34 - 14/01/14 - Lift 1 G-13; Lift 2 1-3
35 - 14/01/14 - Lift 3 G-8
34 - 10/10/13 - Lift 1 G-13; Lift 2 1-3
I am using mail merge to produce reports for lift inspections and it is all going well apart from the fields that are multi value do not quite transfer. For instance the "inspections completed" field has a list of the months Jan-Dec and therefore a visit may have been completed in Jan, Mar & Jul for example.In word the first two letter of the last month are transferred across followed by Chinese symbols.
View 1 Replies View RelatedWe are a non-profit that does blind mailings for our membership drive.
The company who we buy names and addresses from sends us a delimited file that has these fields as the headings
" ID, FULLNAME,COMPANY, ADR1, ADR2, CITY, STATE, ZIP, FIPS"
Once they send out the mailings, people then send in back a remit slip with a contribution that gets scanned through a program that creates a file that gives us these titles
"ALT ID, AMOUNT PAID, RUN DATE, TENDER, FUND, PURPOSE, SOLICITATION, MEMBERSHIP QUESTION, MEMBER TYPE, CONSTITUENT TYPE, SEGMENT". The "ALT ID" and "ID" are the same in both tables.
I need to find a way to merge the tables and combine the fields that have the same ID # , and then have it create a csv file that reads like this (see below) for only the files of the people that responded so that I can import it into our membership software.
"Alt ID","Title","First Name","Middle Name","Last Name","Suffix","Address1","City","State","ZIP","ct y_code","Amount Paid","Run Date","Tender","Fund","Purpose","Solicitation","Me mbership Question","Member Type","Constituent Type","Segment"
I do have another problem with my "Membership Monster" After designing the base with only registential Addess information in the data entry Form. I had to include fields for a separate postal address. This only applies to maybe 10 of 400 entries is there a simple clever way I can copy this data over to the new postal detail fields from the Residential detail feilds ? I thought it may be possible to set thee residential fields as source data. But I am unsure if it is then possible to enter different data over the top if the postal address is different.
I also then need to be able to mail merge the postal details of current members so as print out address labels for the magazine.
I have two databases (files). Each file has a format like the one below.
File 1:
chr start end
chr1 1000 2000
chr2 3000 4000
File 2:
chr start end
chr1 1500 3000
chr2 3750 4000
I want to be able to merge the two records together if the field chr matches between the two files plus if there is an overlap between the start number and end number from each file. For instance the first record from each file would match because the range from 1000 to 2000 of file 1 has numbers consisting of 500 numbers (1500-2000) that are also present and overlap in file 2 (1500-3000). I possibly cannot use < or > since the ranges from each file will vary to different degrees. Perhaps there is a between function that might work...
I'm working on a Word mail merge feature that links to an Access Database and would like to know if you can insert specific fields into the mail merge to refine the terms? example below:
<<Customer Name, [field 2]>> - Or something to that effect.
^The mail merge would know where to obtain the customer name from anyway, but will it select information from the field that is being referenced?
All,
I have a table with about 50,000 records. In the table I have a First Name and Middle Name field. I have created a third field called FULL NAMES.
PROBLEM: How do i combine the data from First Name and Middle Name fields into the FULL Names field in the same table.
Thanks for your help!
I have a very large AccessDB application that I did not create, but am tasked with maintaining/updating. It has a letter Mail Merge with a field list that is in a .txt file on the server. I have new fields that I need to add to the list to be included in the letter. i cannot figure out how to add them? Not very familiar with Mail Merge.
View 7 Replies View RelatedI have two db's that I want to merge. they both have the same field names, but different data and some of the have same ID's, How do I merge them?
View 1 Replies View RelatedIs it possible to add an access field to a mail merge without having to recreate/redo the mail merge?
View 2 Replies View RelatedI am using an MS Access 2010 table as a data source for a mail merge. I would like to update a field in the table with the date that the letter is printed. Is there a way to do this?
View 5 Replies View RelatedHi,
I am trying to "merge" to textfields in a query.
One field is [domene], the other has the name [VLini].
I need these fields to end up like this: DOMAIN/VLINI
I am trying to make a security check with AUTH_USER from the domain user, but it also requires the domain name. Since there are users from multiple domains I need to merge these two in to one field called username.
I have tried:
username: [domene]"/"[VLini] but this only produces a "-1" answer.
Anyone?
What is the best way to do this ..merge one field from one table with another field in a different table to a new field...
View 3 Replies View RelatedI am trying this new project out, and i have two fields set up, Both will be drop down boxes.
One field is Airline, the next Aircraft Type
If the user clicks on the British Airways dropdown link under the "Airline" field, i would the the Aircraft type field to automaticaly pull up only those Aircraft types
that british Airways flys.
Could anyone help me out?