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 Replies


ADVERTISEMENT

Queries :: Creating A Report From A Query With 19 Tickbox Fields

Aug 5, 2014

I am writing a small program for my sons school for there athletics day. We want to register all the students on a data basis. I have a form where you capture all the child's information and then tick box for each event that there will be for the day. So we will only tick the events that the specific child will participate in. I design the table to just import the information from each school from a excel spread sheet directly into the table. What my goal is to print report for each event that will only show the child's names that has register for that specific event and all the different age groups separate. I am stuck at the query and can't seem to get my mind around how to define the query.

View 2 Replies View Related

Creating Conditional Mail Merge From Parameter Query

Apr 2, 2012

I use an access db that stores our customer info on a mssql backend. I need to be able to create a mail merge based on a customers renewal date. Now I do know how to set parameters in a query but is there a way I can use a access report to enter a month and day they are set to renew then have it create the mail merge based on their info?

The Layout is fairly simple just a renewal notice with what they have on their plan.

View 6 Replies View Related

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

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 3 Replies View Related

Queries :: Merge Two Child Fields As String

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

Queries :: Creating Field Names In A Query That Will Automatically Update Each Month

May 10, 2013

I am hoping to create a field name in a query that will change every month. Right now the filed name is qryTechQuintileMonth-7.am_quintile. this designates that the data is for October 2012. There are 6 other fields named similarly for Nov 2012 through April 2013.

Is there a way to name these fields with the proper month-year (mmm-yy) so they automatically update each month?

View 4 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

Queries :: Two Tables Fields Into One Query Field?

Feb 24, 2015

I have two tables: tbltasks & tblsafety

Both tables have a date field in, one table keeps tracks of my tasks the other the expiry date of some safety checks.

I currently have a timed pop up that looks at dates within a table that are within 30 days from now, if there are any dates the reminder pops up.

The problem is I want the pop up to look at two sepearte columns in two different tables, so I figured it would be easier to create a query combining these dates and just ask the pop up to look at that query date column.

I want to create a query that very simply lists all the dates in one column combined from both tables.

View 3 Replies View Related

Creating Non-Calculated Fields In Select Queries

Nov 14, 2005

Hi All!

I am trying to create an updateable non-calculated field in a select query. Specifically, I want to create a Yes/No data type called "Fail".

This is a multiple-user application so I can't solve the problem by using append and delete queries to modify records in a table.

This has turned into a much stickier problem than I anticipated. I would appreciate any insight or advice you have.

View 2 Replies View Related

Queries :: Rank Fields Of A Query Based On Another Field

Jan 18, 2015

I have the query below that return a table like:

PLOTNR; period,Value, ID, Basal_area/ha, Basal_area/ha, perc_BA_sp

What I want to is to add another field that rank the perc_BA_sp by PLOTNR descending (thus highest perc_BA_sp values rank one etc.)

Code:
SELECT[Q:INV1-Basal_area_plot-spp].PLOTNR,
1 AS period,
[Q:INV1-Basal_area_plot-spp].Value,
[Q:INV1-Basal_area_plot-spp].ID,
[Q:INV1-Basal_area_plot-spp].[Basal_area/ha],
[Q:INV1-Basal_area_plot].[Basal_area/ha],
([Q:INV1-Basal_area_plot-spp]![Basal_area/ha]/[Q:INV1-Basal_area_plot]![Basal_area/ha])*100 AS perc_BA_spFROM[Q:INV1-Basal_area_plot-spp]

[code]....

View 1 Replies View Related

Queries :: Union Query For Mail Merge?

Jun 3, 2015

it's possible to use a union query as a mail merge? I haven't found anything that says I can't do it, but I'm not getting my merge to complete, and when I switch to a plain query (and not changing anything else) my merge is successful, so I'm thinking there might be a limitation.

View 14 Replies View Related

Queries :: Merge All Days In One Row - Export Query To PDF

Dec 10, 2014

I have a query that as a result like the attachment below and I want to merge in this case all the days in one row, like also says in the pdf file!

Also there is anyway that the query exports it self to a pdf?

View 3 Replies View Related

Queries :: Multi-field Query Not Working When Some Fields Are Null Value

May 22, 2013

Access 2010. I've had to learn it at work because our DBA was let go and I was the only one willing to give it a go. Read a book or two and picked up some stuff on the internet.

Here's my problem:
I have a simple table -Employee with 4 fields. FirstName, LastName, Office and JobTitle. I have form called Form1 that has 3 control fields cboJobTitle (a combo box that is populated by a query that finds all the unique values of that field in the Employee table), cboOffice (same as above) and txtName (a text box to allow user input) that are used as the criteria for a multi-field query triggered by a button at the bottom of the form. The idea being that you could do a search using this form to find all the employees in one office or all the accountants in one office, or any other combination.

The main search query has the following criteria for each field -
Like [forms]![Form1]![cboOffice] & "*"
Like [forms]![Form1]![cboJobTitle] & "*"
Like [forms]![Form1]![txtName] & "*"

It works great...until I enter a record where one of those fields may be null, such as if I leave the JobTitle blank.
If I have two employees in an office in one city and then do a search for all the employees in that office, it only returns one record and ignores the one that has the null value in the JobTitle field.

View 14 Replies View Related

Can Merge / Combine 2 Or More Crosstab Queries Into ONE Single Query?

Aug 27, 2011

Because I have more than 3 queries, it is really hard for me to manage. Therefore, I was thinking of having 3 crosstab queries to show in one single query. This way it will save my time from moving back and forth.

How to do that? Is it possible? If so, how?

View 5 Replies View Related

Modules & VBA :: Creating Mail Merge Letter

Aug 20, 2013

I basically have a form which the record source is either from a table or query and all I would like to do is to have a button which when pressed will open up a previously created word template and insert all relevant fields into the template. First Name, Last Name, Address etc.

View 1 Replies View Related

Queries :: Query That Populates A Report Linked To Mail Merge

Aug 30, 2013

I have a query that populates a report linked to a mail merge. There is an IFF statement in it that checks to see if a condition is meet. If that condition is meet some standard text results. Is it possible to put a disclaimer with the standard text.For example,

Code:
IIF ([Results]="Negative","Nothing detected" (the disclamer would go here)

I am not certain the correct syntax to use to insert "not all regions were tested".

View 1 Replies View Related

Queries :: Design A Query To Show Only Empty Field As TEXT Fields In Table

Mar 2, 2014

I am just querying a single table, no relationship involved with another table. As you can see form the attached jpeg, the ZIP field in some cases is empty. I would run a search using Is NULL but the field is NOT numerical. It's a long story but I had to make this field a TEXT field. Basically, what statement do I have to insert in the criteria field to just pull up the EMPTY ZIP fields?

View 2 Replies View Related

Creating Mail Merge From Preferred Mailing Address

Nov 5, 2012

I'm a very new user of Access. I am creating a contacts database (3000+ contacts), with up to 6 addresses per contact, though most will only have around three. I'd like to find the best way to select the preferred mailing address (using a combo box??) in order to be able to regularly creating mailing labels (and letter mail merges).

View 4 Replies View Related

Creating A List, From A LINK (Join) Table, For Use In Mail Merge

Oct 28, 2005

I am creating a mail-merge application.

The data stored will be dealing with Students and Qualifications that they have attained. The link table in the relationships shown/attached, allows a Student to have multiple qualifications.

When I merge the data, I will need to list all of the qualifications that each student has attained, which will need to be either in a item list, or in a comma-separated list.

The list will need to be pulled from the link table (StudentQualifications). For example:

StudentID #1 >> Qualification #1 Description
StudentID #1 >> Qualification #2 Description
Etc
Etc

So, when the data is merged, it will specify that:

StudentID #1 has acheived Qualification #1 and Qualification #2 and Etc, Etc.

How can I create this list in the first place, which can then be used in the source of the merge for the document.

Any ideas as to how I can pull multiple information into either a single string to pass to the merge or into a list in the document would be appreciated.

Graham

View 2 Replies View Related

Creating A Query Not Between 2 Date Fields

Aug 18, 2011

I am trying to finish off my database with this last query. I have two fields named date_to and date_from, within a table tbl_non_avail . I need to show people who are available not between the from and to dates.

View 3 Replies View Related

Creating Expression On Multiple Date Fields In A Query

Jun 12, 2014

I am trying to create an expression in a query to sum only the # of hours a student attended between two date fields. I do not want to use a parameter because each student has different start and midpoint dates and I need to see all of them in one list.These are the fields I'm using in the query:

Student Name
Start Date
Midpoint Date
Hours

It keeps giving me "0" or if I move the () around it says the correct syntax is [NOT]

Expr1: Sum([Hours]) between [Start Date] & [Midpoint]))

View 14 Replies View Related

"Merge" To Text Fields In Query.

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

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







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