Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. 04-23-2016, 08:47 AM #16
    CJ_London
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,845
    cap - it is basic maths - 0.99=99% 1.05 = 105%



    if you want +- 0.5 of a unit then

    IIf(Nz([AIDSocketPU],0)>=Nz([SIDSocketPU],0)+0.5 And Nz([AIDSocketPU],0)<=Nz([SIDSocketPU],0) -0.5

    I really think you can work this out for yourself
    Reply With Quote Reply With Quote
  2. 04-24-2016, 01:29 AM #17
    cap.zadi
    cap.zadi is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2011
    Location
    KSA
    Posts
    481
    Yeah u are right its basics but was confused to fix in the statement. Anyways thanks for ur great help.
    Reply With Quote Reply With Quote
Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Using my vba function in calculated field ..
    By fekrinejat in forum Programming
    Replies: 5
    Last Post: 04-07-2015, 03:35 PM
  2. using Nz function in a field
    By danieltaylor in forum Programming
    Replies: 4
    Last Post: 11-05-2012, 06:52 AM
  3. When text field is used in Sum() function, it is adding them like the field is number
    By teja in forum Access
    Replies: 2
    Last Post: 03-30-2012, 07:39 AM
  4. Date Function as Field Name
    By Kirsti in forum Queries
    Replies: 7
    Last Post: 03-21-2012, 04:18 PM
  5. sum function counting field name I think...
    By sfgiantsdude in forum Access
    Replies: 16
    Last Post: 03-06-2012, 04:42 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