Learn when you want, where you want with convenient online training courses. Sign up now!
LEFT JOIN States ON Staging.[Recipient State/Province] = States.StateID
WHERE (((States.StateID) Is Null));
Open in new window
Experts Exchange Solution brought to you by
"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.
In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.
'Delete the previous query (if it exists)
If DCount("Name", "msysObjects", "Name='qryTemp'") = 1 Then
DoCmd.DeleteObject acQuery, "qryTemp"
Dim qdfNew As QueryDef
Dim strSQL As String
Dim strSQL1 As String
Dim strSQL2 As String
Dim strFieldName As String
'--How the Field name is specified-----
' A combob box provied the field Names
'strFieldName = Me.Combo5
' The user types in a field name
'strFieldName = InputBox("What Field")
'Build the SQL string
strSQL1 = "SELECT YourTable.ID, YourTable.YourRequiredField, YourTable.YourStateField,YourTable.["
strSQL2 = "] FROM YourTable;"
strSQL = strSQL1 & strFieldName & strSQL2
'Load the SQL into a text box for viewing, or copying to the SQL editor
Me.txtSQL = strSQL
'Create the saved Query
Set qdfNew = CurrentDb.CreateQueryDef("qryTemp", strSQL)
'Refresh the database window/task Pane
Open in new window
Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.
From novice to tech pro — start learning today.
Premium members can enroll in this course at no extra cost.