Microsoft Access String Concatenation, Double Double Quotes, Single Quotes, Dates, Times TechHelp

In this Microsoft Access tutorial, I'll show you how to use string concatenation to join two fields together in a query, and in a VBA text string. Using quotes, single quotes, double quotes, double-double quotes, can be confusing. We'll try to sort it all out.
RESOURCES:

Concatenation Tip:
https://www.youtube.com/watch?v=zzrd4tjPiYY

SQL Basics:
https://www.youtube.com/watch?v=ULEmUobUWqc
These lessons cover string concatenation in more detail:

Access Beginner 9: http://599CD.com/X4Z37
- Tracking Contact History
- Data Integrity
- Report Design From Scratch
- String Concatenation
- Report vs. Page Header & Footer
- Can Grow / Can Shrink Properties
- Records from a Specific Date
- Explicit Query Parameters
- Report Formatting

Access Expert 8: http://599CD.com/X48SW
- Order Entry System
- Order Form and Details Subform
- Calculated Query Fields
- Figuring Sales Tax if Taxable
- IIF Function (If/Then/Else)
- Proper Rounding of Values
- Bankers Rounding
- Nesting Functions
- Final Product and Tax Totals

Access Expert 25: http://599cd.com/X8SCG
- String Functions
- Left, Right, Mid, InStr, InStrRev, Len
- LCase, UCase, Trim, RTrim, LTrim
- Replace, Str, CStr, StrComp, ASC, CHR
- Space, String
- Logical Functions
- IsDate, IsNull, IsNumeric, IsError
- NZ, VarType, TypeName
- And, Or, Not, Xor, IIF, Nested IIF
- Switch, Choose

Access Developer 2: http://599CD.com/XESUG
- Building a Calculator Form
- Basic Debug, On Error Resume Next
- Creating Subs with Parameters
- Select Case Statements
- Creating Functions
- Returning Values from Functions
- Comments, Line Continuation
- More MsgBox Options
- RunSQL, Insert Into
- Lots more
Your Questions Answered: http://599cd.com/TechHelp
FREE Access Level 1: http://599cd.com/X113
$1 Access Level 2: http://599cd.com/X322
Learning Connection 50% OFF: http://599CD.com/XYTCNCT

Richard's Blog: http://599cd.com/blog
Access Learning Zone Facebook Group: http://599CD.com/XZBTD
Twitter: https://twitter.com/LearningAccess

https://en.wikipedia.org/wiki/Microsoft_Access
https://products.office.com/en-us/access
https://www.microsoft.com/en-us/microsoft-365/blog/access/

Email Me: amicron@gmail.com
NOTES:

FullName: FirstName & LastName
FullName: FirstName & " " & LastName
FullName: LastName & ", " & FirstName
FullQuote: "She said, ""Hello, Brent."""
FullQuote: "She said, ""Hello, " & FirstName & "."""

S = "Hi there, Brent"
FN = "Brent"
S = "Hi there, " & FN
S = "Hi there, " & FN & ". Today is a nice day."

Sally said, "hello, Brent."
S = "Sally said, ""hello, Brent."""
S = "Sally said, ""hello, " & FN & "."""
S = "Sally said, ""hello, " & FN & "."""

SELECT * FROM CustomerT WHERE FirstName="Brent"
S = "SELECT * FROM CustomerT WHERE FirstName=""Brent"""
S = "SELECT * FROM CustomerT WHERE FirstName='Brent'"
S = "SELECT * FROM CustomerT WHERE FirstName=""" & FN & """"
S = "SELECT * FROM CustomerT WHERE FirstName='" & FN & "'"

Видео Microsoft Access String Concatenation, Double Double Quotes, Single Quotes, Dates, Times TechHelp канала Computer Learning Zone