Page 2 of 2 FirstFirst 12
Results 16 to 18 of 18
  1. #16
    HiTechCoach's Avatar
    HiTechCoach is offline MS MVP - Access Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jul 2010
    Location
    Oklahoma, USA
    Posts
    702

    I also noticed that you in and out field are not numeric data types. I would recommend fixing this.

  2. #17
    honey2wood is offline Novice
    Windows 7 Access 2007
    Join Date
    Nov 2010
    Posts
    25
    Hi again Hitechcoach,

    Many Many thanks for that. That was the way I have been trying to solve it but I was getting the Me. , " and & in the wrong order / combination. I even tried to strip away other field and just have the amount which did work but went bad when I added anything else.
    This now works fine.
    Thanks for the numeric advice.

    Cheers again.
    Graham
    Not sure how to label this post as solved

  3. #18
    HiTechCoach's Avatar
    HiTechCoach is offline MS MVP - Access Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jul 2010
    Location
    Oklahoma, USA
    Posts
    702
    You're welco0me.

    Glad we could assist.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Accessing different parts of the same form
    By Lxmanager in forum Forms
    Replies: 1
    Last Post: 10-21-2010, 04:52 PM
  2. Product / Stock Management
    By dale.90 in forum Access
    Replies: 1
    Last Post: 09-30-2010, 11:08 AM
  3. field parts
    By DavidAlan in forum Queries
    Replies: 3
    Last Post: 09-07-2010, 01:36 PM
  4. Find all parts in a heirarchy
    By Spiftacu1ar in forum Queries
    Replies: 1
    Last Post: 08-04-2009, 09:01 AM
  5. Product in a Summary Query
    By Fletch in forum Queries
    Replies: 0
    Last Post: 12-11-2008, 03:14 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