Calculation Expression Help

  • Thread starter Thread starter SITCFanTN
  • Start date Start date
S

SITCFanTN

I'm trying to add to my query the percentage of New Business Issued with a
Downpayment. In my query I'm counting the "RecordID" to count All New
Business Accounts and accounts with DownPayment have a code in the
DownPaymentCode field. I'm counting NB with Down Payments with the criteria
"is not Null". Now I'm trying to calculate in the Expression "PercentWithDP"
the New Business issued with Downpayments with the following
expressionhowever the result is zero.


PercentWithDP: [NBIssuedWithDP]\[NBIssued]

NBIssued: RecordID
NBIssuedWithDP: DownPaymentCode
 
Just a quick glance without reading or attempting to understand your records
and structure, your division sign is backwards. Using \ rather than / will
perform integer division. Results get rounded down to integers so every value
between 0 and 0.9999 will return 0.
 

Ask a Question

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.

Ask a Question

Similar Threads

Problem with Dupl Query 4
sort report based on calculated field 2
Sorting on Calculated Field 5
Easy Count Question 6
Access Dcount (multiple criteria) 3
Issues with Left Join 1
Calculating Interest Payments? 2
How do i make a Payment Calculator 1

Back
Top