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 Replies
ADVERTISEMENT
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
Nov 9, 2006
Hi,
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?
View 3 Replies
View Related
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
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
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
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
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
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
Mar 28, 2013
How to merge two fields at one in report
View 4 Replies
View Related
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 3 Replies
View Related
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
Feb 28, 2006
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...
View 1 Replies
View Related
Jan 14, 2014
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
View 14 Replies
View Related
Jan 14, 2014
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 Related
Feb 27, 2014
We 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"
View 4 Replies
View Related
Jul 2, 2014
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.
View 5 Replies
View Related
Mar 25, 2014
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...
View 7 Replies
View Related
Nov 19, 2013
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?
View 2 Replies
View Related
Nov 21, 2007
Hi all. Is there some way to merge 2 tables into one in a query? Is it possible? Thank u.
View 7 Replies
View Related
Nov 21, 2007
Dear all
I need to merge a number of databases of the same type into one database in access. can you please help me with code itself.
thanks.
Ampah
View 2 Replies
View Related
Jan 30, 2008
I am making this harder than it has to be i'm sure. I had a previous post of auto-texting a field, well why can't I just take two fields I have, such as the ID field which is an autonumber field and combine that with a type field that I have which is D.
If I could merge this in a query, wouldn't it give me the results as D01, D02, etc?
I couldn't find anything helpful online, one side said do the following.
SELECT receivables2.type+receivables2.ID
FROM receivables2;
Only I get errors.
I also tried this.
SELECT merge(receivables2.type; receivables2.ID);
FROM receivables2;
But it says merge is an invalid expression.
Could someone please help?
View 6 Replies
View Related
Apr 15, 2008
Dear Friends,:)
I have 2 tables .. (GroupNo.) & (employee)
The conjunction between them as :
tbl1 tbl2
--------------------------
No. Name
--------------------------
1 John
1 Alian
1 Sali
2 Robert
2 ......
...
..
.
---------------------------
How Can I make a new Query that produce the result as :
1 John,Alian,Sali
2 Robert,.......
3 ......
Kind Regards,
View 7 Replies
View Related
Aug 19, 2005
I have a database on a machine with office xp. I store the database in C:Database.
I can run a query then link the results of that query to a template document I have setup via mail merge. The document then opens and fills out the fields based on the query results.
I transferred the database onto another machine with office 2003 and put it in exactly the same directory c:database. and when i try to link the query to word, word just comes up saying it cant find the source.
I have gone around various machines at work and the merge runs fine on all machines with office xp and not with 2003.
Any Ideas?
View 1 Replies
View Related
Sep 13, 2006
I have four tables, each containing name of one family member. Dad, Mom, son, and other. One of the four called us, and in many instances, they ask that we send a letter to them. Sometimes, they say, send the letter to Mom, or send it to dad, or sis. We are creating an automated output query to print one of two letters, to go to the appropriate person. Depending on which person is selected as the one to receive mail, we need to merge out into Word that person's data, which may be in any of the four tables, but is the only one bearing an indicator (checkmark, etc).
Don't know how to word the query to look thru the data on that family (from four tables) and select the indicated one, output the address info.
View 2 Replies
View Related
Sep 15, 2006
I have a form on which users select fields to include in a query and can select their parameters. The query itself is then created using an SQL statement in the VBA behind the form.
I want to be able to use the records which this query selects through mail merge. With a standard query, this is easy because from within Word I can choose the query through the mail merge settings. However, since the query doesn't exist in this case (it is created every time it's run using VBA) I can't figure out how to do it.
Ideally, I want the form to come up during the mail merge process so that the user can specify which records to use, but I can't select a form as a mail merge source.
Can anyone help?
Gary
View 14 Replies
View Related
