Query criteria to find whole dollar amonts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

can someone help me with a way to find whole dollar amonts for
PDetail.DETAIL_LINE_AMT

SELECT PDetail.RECEIPT_NUM, PDetail.DETAIL_LINE_AMT, PDetail.DETAIL_ITEM_PRC
FROM PDetail;
 
Mike,

If you are only looking for those records where the Detail_Line_Amt is an
integer ($1.00, $5.00, etc.) then you could try a WHERE clause that looks
like:

WHERE [Detail_Line_Amt] = ccur(int([Detail_Line_Amt]))

If what you want is to round down the Detail_Line_Amt to the next lower
whole number, then use:

SELECT PDetail.RECEIPT_NUM,
INT(PDetail.DETAIL_LINE_AMT) as IntLineAmt,
PDetail.DETAIL_ITEM_PRC
FROM PDetail;

HTH
Dale
 
Thanks Dale
I am looking for 1.00 and 5.00

Works great

Dale Fye said:
Mike,

If you are only looking for those records where the Detail_Line_Amt is an
integer ($1.00, $5.00, etc.) then you could try a WHERE clause that looks
like:

WHERE [Detail_Line_Amt] = ccur(int([Detail_Line_Amt]))

If what you want is to round down the Detail_Line_Amt to the next lower
whole number, then use:

SELECT PDetail.RECEIPT_NUM,
INT(PDetail.DETAIL_LINE_AMT) as IntLineAmt,
PDetail.DETAIL_ITEM_PRC
FROM PDetail;

HTH
Dale
--
Don''t forget to rate the post if it was helpful!

Email address is not valid.
Please reply to newsgroup only.


Mike said:
can someone help me with a way to find whole dollar amonts for
PDetail.DETAIL_LINE_AMT

SELECT PDetail.RECEIPT_NUM, PDetail.DETAIL_LINE_AMT, PDetail.DETAIL_ITEM_PRC
FROM PDetail;
Click to expand...
Click to expand...
 
Glad I could help.

Have a Happy Thanksgiving, and don't forget to give thanks for the
sacrifices of our service members and their families.

Mike said:
Thanks Dale
I am looking for 1.00 and 5.00

Works great

Dale Fye said:
Mike,

If you are only looking for those records where the Detail_Line_Amt is an
integer ($1.00, $5.00, etc.) then you could try a WHERE clause that looks
like:

WHERE [Detail_Line_Amt] = ccur(int([Detail_Line_Amt]))

If what you want is to round down the Detail_Line_Amt to the next lower
whole number, then use:

SELECT PDetail.RECEIPT_NUM,
INT(PDetail.DETAIL_LINE_AMT) as IntLineAmt,
PDetail.DETAIL_ITEM_PRC
FROM PDetail;

HTH
Dale
--
Don''t forget to rate the post if it was helpful!

Email address is not valid.
Please reply to newsgroup only.


Mike said:
can someone help me with a way to find whole dollar amonts for
PDetail.DETAIL_LINE_AMT

SELECT PDetail.RECEIPT_NUM, PDetail.DETAIL_LINE_AMT,
PDetail.DETAIL_ITEM_PRC
FROM PDetail;
Click to expand...
Click to expand...
Click to expand...
 
Back
Top