No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
I have been working on a database in MS Accesss. I am trying to generate a query in the SQL view but the introduction to SQL class I am taking did not cover how to incorporate multiple WHERE conditions. Here is the query so far... SELECT intFID, COUNT(*) AS TotalAudits, … |
|
I am having trouble getting this to work in a subform My Form is called frmFacilities My Subform is called QAMain subform The first combo box in the QAMain subform is RiskLevel Its Row Source is: SELECT tblRiskLevel.RiskLevel, tblRiskLevel.Description FROM tblRiskLevel ORDER BY tblRiskLevel.RiskLevel; Its Event is: Private Sub RiskLevel_AfterUpdate() … |