Access query, ignores a multiplier uses a 1 value instead

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

Guest

In the same query this works:
q_103_G_RetPr_AnyYr:
FormatCurrency(([q_102_PrIncrMult_AnyYr_GovRet]*[t_104_G_RetPrFr_2000_Inc_4MtArtFrSand]),2,No,Yes,Yes) and this does not:
q_105_G_NewGovPr_AnyYr:
FormatCurrency(([q_102_PrIncrMult_AnyYr_GovRet]*[t_104_G_GovPrFr_2000_Inc_4MtArtFrSand]),2,No,Yes,Yes)


For the second, I get the value of second expression correctly, but
un-multiplied! Help! Why does the same first expression work in the first
case but not the second? There is no error dialog.
 
FrankJDS said:
In the same query this works:
q_103_G_RetPr_AnyYr:
FormatCurrency(([q_102_PrIncrMult_AnyYr_GovRet]*[t_104_G_RetPrFr_2000_Inc_4MtArtFrSand]),2,No,Yes,Yes) and this does not:
q_105_G_NewGovPr_AnyYr:
FormatCurrency(([q_102_PrIncrMult_AnyYr_GovRet]*[t_104_G_GovPrFr_2000_Inc_4MtArtFrSand]),2,No,Yes,Yes)


For the second, I get the value of second expression correctly, but
un-multiplied! Help! Why does the same first expression work in the first
case but not the second? There is no error dialog.
Click to expand...


Use vbTrue (or -1) instead of Yes and vbFalse (or 0) instead of No.
 
Back
Top