Access SQL Seminar Part 2

News User Comments History Notify Me

5/17/2011 12:25:14 AM
Access SQL Seminar Part 2
By Richard Rost

This nearly five (5) hour long video seminar will pick up where Part 1 left off. You will learn more about the SQL programming language. We will focus on action queries, aliases, joins, crosstabs, union queries, aggregate functions, and more.

This seminar has several goals. You will:

1. Learn about Action queries and when to use them
2. Discover how to launch queries from VBA code
3. Create Aliases for your field and table names
4. Learn the different types of Table Joins
5. Construct a Union query
6. Work with a Crosstab query
7. Perform calculations in your SQL statements
8. Explore the different Aggregate query functions
9. Utilize string, math, time/date, and other query functions

Click here for more information on the SQL SEMINAR PART 2.

Permanent Link
Course Link: Access SQL Seminar Part 2
Keywords: access sql structured query language
Page Tag: whatsnew

Post Reply

Insert New Line in Query Field Comment from David Spens @ 5/24/2011

I have watched but not yet learned and digested the whole of this seminar and have nothing bur praise for it and its presentation. Well done, Rick.
Can you help on one small point woncerning string concatenation, please.
Is there a code or character or other means to force a Line Feed and Carriage Return within a concatenation?
I have a database containing the following fields,
Address1, Address2, Address3, Town, County, PCode, and would like to amalgamate all those three into one field called Address but with each original field on a new line. Can that be done?
Many thanks,
David

Reply from Richard Rost:

Sure. You can say:

FullAddress: [Address1] & Chr(13) & Chr(10) & [Address2] & Chr(13) & Chr(10) & [Address3]

That will insert CARRIAGE RETURN and LINE FEED characters between your fields, giving you the desired effect.

Keep in mind, however, that I strongly recommend you leave all 3 address fields SEPARATE in your table, and just assemble them as needed in a query.

Show Just This Thread Post Reply

Add Your Comments or Subscribe

If you just want to subscribe to get email updates when the News is updated, then enter your name and email address and check the Notify Me box below. If you would optionally like to add your comments below to be posted, they are welcome.
Your Name:	Required
Your Email:	NOT Public
Subject:
Comments:
	Sorry about this step. It's just to keep the spam bots away:
Verify:	What is 4+3:

	Notify me when the News is updated.
	Remember Me for my next comments


Please do not use this form for Customer Service inquiries! If you have questions about your account, shipping info, courses you've ordered, need passwords, etc. please use the Customer Service Center instead. I value your comments. They will be displayed on this page (above). Your name will be displayed, but your email address will not be. As always, I promise to never give away your personal information to anyone else, ever. NOTE: If you don't leave your name and email address, DON'T expect a reply. I can't promise a personal reply to everyone who posts here. I TRY my best, but I cannot guarantee it. If you don't leave your real name and email address, I won't even bother. I usually just hit DELETE. -Richard