Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ArlinR

    MS Access Query - Val() is returning "short date" rather than int.

    I must have been hung up in Excel land!!!
  2. ArlinR

    MS Access Query - Val() is returning "short date" rather than int.

    Thanks Duane. I'm sure that's the problem. Duh!! I feel kind of stupid. I'll put the SUM in for the bottom of the report. Thanks, Arlin
  3. ArlinR

    MS Access Query - Val() is returning "short date" rather than int.

    I've discovered what the "wierd" number is. If I have 3 lines of Sales Orders and on each line, I have a SOD_RequiredQty and a Labels Per (Expr2) and I use the expression =SUM([SOD_RequiredQty]*[Expr2])on the line, the value returned on each line is the total of all of the "Sums" calculated...
  4. ArlinR

    MS Access Query - Val() is returning "short date" rather than int.

    What's confusing to me is that it returns an integer for printing "Expr2", but when used in a calculation, it seems to be grabbing something else. I think it must have something to do with pulling in more than a single value for the calculation, since the calculated value is replicated on every...
  5. ArlinR

    MS Access Query - Val() is returning "short date" rather than int.

    In my report, I have SOD_Required Qty visible and I have Expr2 visible on the line. However, the calc doesn't work. Here's the SQL view: SELECT Shipment.SH_ShipToName, SalesOrder.SOM_SalesOrderID, Shipment.SH_ShipDate, Item.IMA_ItemID, SalesOrderDelivery.SOD_RequiredQty...
  6. ArlinR

    MS Access Query - Val() is returning "short date" rather than int.

    Hi Skip, I changed the query to Expr2: CInt([Field_Name]) In the report I get Expr2 showing correctly. e.g 100 However, when I try to use Expr2 in the following calculation =Sum([SOD_RequiredQty]*[Expr2]) I get 36,502 as the result, regardless of the two sides of the equation. SOD_RequiredQty is...
  7. ArlinR

    MS Access Query - Val() is returning "short date" rather than int.

    Unfortunately I'm on the road at the moment, and won't be able to try it until tomorrow AM. I'll let you know how it works? Thanks, Arlin
  8. ArlinR

    MS Access Query - Val() is returning "short date" rather than int.

    Hi Skip, Like this? Instead of Expr1: Val([Field_Name]) use Expr1: CInt([Field_Name]) Thanks, Arlin
  9. ArlinR

    MS Access Query - Val() is returning "short date" rather than int.

    I'm using Val() in an Access Query and my expression is a field in my database that consists of left aligned numbers in a varchar column, such as 100, 200 etc. Val is returning 4/9 for 100. In other words April 9 which is the 100th day of the year. What can I do to get integers returned...

Part and Inventory Search

Back
Top