mistyinca1970
Member
- Local time
- Yesterday, 20:17
- Joined
- Mar 17, 2021
- Messages
- 117
Hello,
I have a query that is tied to a form that will show records based on the user's division in the org. The criteria comes from a TempVars captured at login. What value would I need to get in this field to return records for all divisions?
...so in this WHERE statement above with the TempVars, what value will not restrict the records return. I tried "*" and that didn't work.
Thank you,
I have a query that is tied to a form that will show records based on the user's division in the org. The criteria comes from a TempVars captured at login. What value would I need to get in this field to return records for all divisions?
Code:
SELECT tblContracts.ID, tblContracts.Division, tblContracts.ContractNo, tblContracts.ContractEntity, tblContracts.AssignedMonitor, tblContracts.ContractType, tblContracts.OriginalDate, tblContracts.ContractDate, tblContracts.ExpirationDate, tblContracts.Parity, tblContracts.ParityExpiration, tblContracts.EffectiveExpDate, tblContracts.Documents, tblContracts.OriginalAmount, tblContracts.TotalAmount, tblContracts.RenewalTerms, tblContracts.Comments, tblContracts.CurrentAmount, tblContracts.AmendedAmount, tblContracts.Funding, tblContracts.FundingAmt, tblContracts.Amendments, tblContracts.Closed, tblContracts.FileLink, tblContracts.ClosedDate, tblContracts.Status
FROM tblContracts
WHERE (((tblContracts.Division)=[TempVars]![UserDivision]) AND ((tblContracts.Status)<>"Closed"));
Thank you,