Results 1 to 3 of 3
  1. 02-12-2024, 04:43 PM #1
    Middlemarch
    Middlemarch is offline Competent Performer
    Windows 10 Access 2019
    Join Date
    Mar 2015
    Posts
    365

    Access calculation qyery

    Why does ? int("2-") = -2 ?
    Reply With Quote Reply With Quote
  2. 02-12-2024, 06:25 PM #2
    davegri's Avatar
    davegri
    davegri is offline Excess Access
    Windows 11 Access 2019
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,413
    ?IsNumeric("2-") returns true.

    VBA assumes "2-" to be an expression evaluating as numeric.
    Reply With Quote Reply With Quote
  3. 02-12-2024, 06:47 PM #3
    Middlemarch
    Middlemarch is offline Competent Performer
    Windows 10 Access 2019
    Join Date
    Mar 2015
    Posts
    365
    OK, thanks.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Trying to do a calculation in Access
    By The X-Man in forum Access
    Replies: 5
    Last Post: 01-31-2020, 11:58 PM
  2. doing a calculation with Access
    By ntambomvu in forum Programming
    Replies: 2
    Last Post: 07-30-2018, 08:01 AM
  3. Doing calculation in access
    By Johanb26 in forum Access
    Replies: 3
    Last Post: 07-25-2014, 04:21 PM
  4. Qyery result to display on form
    By keiath in forum Forms
    Replies: 5
    Last Post: 02-15-2014, 06:50 PM
  5. Calculation Field in table vs Query calculation
    By Leonidsg in forum Database Design
    Replies: 18
    Last Post: 02-28-2013, 09:38 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums