• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 189
  • Last Modified:

Populate data from query

Experts,
I have attached a Word document that better outlines my objective. I have also attached the latest revised db. I have a need to combine two queries to get me one result. Saving-correct-Area-Support-Mana.docx  StoreBonusRev.mdb
0
Frank Freese
Asked:
Frank Freese
  • 4
  • 3
1 Solution
 
Rey Obrero (Capricorn1)Commented:
try this revision

And tblDesignatedEmployee.EmployeeTypeID In (4,5)
0
 
Frank FreeseAuthor Commented:
Here's the change I enetered:
AreaSM: (Select [tblEmployee.EmployeeID] 
 FROM tblEmployee INNER JOIN tblDesignatedEmployee  
ON tblEmployee.EmployeeID = 
tblDesignatedEmployee.EmployeeID 
Where tblDesignatedEmployee.StoreID
 = tblStore.StoreNumberID 
And tblDesignatedEmployee.EmployeeTypeID=(4,5)

Open in new window

And here's the error I got:
The expression you entered is missing a closing parenthesis, bracket or verticle bar
0
 
Rey Obrero (Capricorn1)Commented:
missing ")" at the end


AreaSM: (Select [tblEmployee.EmployeeID] 
 FROM tblEmployee INNER JOIN tblDesignatedEmployee  
ON tblEmployee.EmployeeID = 
tblDesignatedEmployee.EmployeeID 
Where tblDesignatedEmployee.StoreID
 = tblStore.StoreNumberID 
And tblDesignatedEmployee.EmployeeTypeID=(4,5))

Open in new window



0
Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

 
Frank FreeseAuthor Commented:
ok...did that with this error:
The expression you entered contains invalid syntax. You may have entered an operand without an operator.

0
 
Rey Obrero (Capricorn1)Commented:
oh my ... i posted  In(4,5)  and you copied  =(4,5)..



AreaSM: (Select [tblEmployee.EmployeeID]
 FROM tblEmployee INNER JOIN tblDesignatedEmployee  
ON tblEmployee.EmployeeID =
tblDesignatedEmployee.EmployeeID
Where tblDesignatedEmployee.StoreID
 = tblStore.StoreNumberID
And tblDesignatedEmployee.EmployeeTypeID In (4,5))
0
 
Frank FreeseAuthor Commented:
well stupid me! that looks to have nailed it. again, thank you
0
 
Frank FreeseAuthor Commented:
thanks
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now