D
Duane Hookom
Oh yes it does! From what I can see there is absolutely no wrong results, no
error messages, and no issues.
error messages, and no issues.
Duane said:Could you share some SQL views?
Duane said:You can view a query in SQL view. Then copy and paste the SQL into a reply.
Duane Hookom
MS Access MVP
Duane said:Are you suggesting that records are displaying in the query where the
numeric value of DCINo is not between the numeric value in txtDCIStart and
txtDCIEnd? How about using the Query->Parameters to define the data type of
your text boxes. Also, is RewEffort text or numeric?
Duane said:I have heard of issues with Decimal type fields. Try:
qtotActEffort:
SELECT Sum(DCI.ActEffort) AS SumOfActEffort
FROM DCI
WHERE (Val(DCI.DCINo) Between Val(Forms!frmReportInput!txtDCIStart) And
Val(Forms!frmReportInput!txtDCIEnd));
Query2:
SELECT DCI.DCINo, DCI.RewEffort, qtotActEffort.SumOfActEffort
FROM DCI, qtotActEffort
WHERE Val(DCI.DCINo) Between Val(Forms!frmReportInput!txtDCIStart) And
Val(Forms!frmReportInput!txtDCIEnd) And
Val(DCI.RewEffort)>Val(Forms!frmReportInput!txtRwkVal);
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.