Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2008

    Creating INT function within a Query

    A little confused about this...

    I need one field in the query to calculate an integer based off of two other fields, here is my code:

    Int ([Pieces])/[Master Carton Qty]

    It is dividing but not rounding down, gives me 6.25 for example.

    Any help is appreciated, thanks!

  2. #2
    jya is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2007
    Have you tried this?

    Int([pieces]/[Master Carton Qty])

  3. #3
    Join Date
    Jan 2008
    Yes, that is how I have it actually was in a hurry and typed it incorrectly here.

    Also with this it treats pieces and MCQ like parameters... I have this same code in a different query and it works perfectly?? A little confusing.


  4. #4
    Join Date
    Jan 2008
    Sorry I am an idiot, I figured it out as soon as I got here! 8)

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 03-23-2010, 04:01 PM
  2. Is there a function to do this....
    By Nowherefast in forum Access
    Replies: 2
    Last Post: 12-31-2008, 08:08 AM
  3. Query using count function
    By wasim_sono in forum Queries
    Replies: 0
    Last Post: 11-28-2007, 03:16 AM
  4. Replies: 0
    Last Post: 02-14-2007, 01:35 PM
  5. Creating multiple reports from one Query
    By Mike Cooper in forum Reports
    Replies: 5
    Last Post: 04-24-2006, 05:00 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
Other Forums: Microsoft Office Forums