Results 1 to 7 of 7
  1. #1
    somabakr is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Dec 2015
    Posts
    4

    Question Database for price offers and revisions

    Dear all,



    I'm trying to make a database for price offers and it's revisions but when I make a report for the offers all the revisions being listed, but I need only the last revision for every offer

    please help me in the above issue.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Difficult without knowing your data structure. Does this help?

    http://www.baldyweb.com/LastValue.htm
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    somabakr is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Dec 2015
    Posts
    4
    thank u very much i think it will work, i'll try and feed u back

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    No problem, and welcome to the site by the way!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    somabakr is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Dec 2015
    Posts
    4
    Click image for larger version. 

Name:	Offers Database.jpg 
Views:	14 
Size:	227.3 KB 
ID:	23214
    please find the my database layout

  6. #6
    somabakr is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Dec 2015
    Posts
    4
    i need a simple way to create a report or query to calculate the total amount of the last revision taking into consideration that each revision contain one BOQ which contains more than one item.

  7. #7
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    The first thing I would do is clean up the object names.

    Shouldn't use spaces, punctuation or special characters (underscore is the exception) in object names. You have slash, apostrophe, parenthesis, dash and question marks in object names. This will cause you headaches.........


    I'm just sayin............

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

Similar Threads

  1. Replies: 17
    Last Post: 12-14-2015, 10:23 PM
  2. Help with inventory and price database
    By Udyr2g in forum Database Design
    Replies: 4
    Last Post: 06-18-2014, 09:39 PM
  3. Price of building a database
    By bking in forum Access
    Replies: 6
    Last Post: 06-12-2014, 08:24 PM
  4. First Database attempt _ Price Design Flow
    By KenozGG in forum Database Design
    Replies: 2
    Last Post: 05-29-2014, 10:50 PM
  5. Price book database
    By tommyried in forum Import/Export Data
    Replies: 9
    Last Post: 12-10-2013, 12:37 AM

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