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:
• Microsoft Access String Concatenation
SQL Basics:
• Microsoft Access SQL Basics
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: / learningaccess
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://www.microsoft.com/en-us/micro...
Email Me: [email protected]
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 & "'"
Watch video Microsoft Access String Concatenation, Double Double Quotes, Single Quotes, Dates, Times TechHelp online without registration, duration hours minute second in high quality. This video was added by user Computer Learning Zone 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 14,02 once and liked it 19 people.