Results 1 to 4 of 4
  1. #1
    LOIZOS is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2014
    Posts
    17

    Second Query is not Runninin in A Command Button acess 2007

    Hi,
    I have A command Button containing 2 queries to Update two Different Tables.
    With the one query is running ok. When I am adding the second one even the first one is not running
    Why?

    Somebody help



    Thanks

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,850
    We only know what you show or tell us. Please post some details, code.....

  3. #3
    LOIZOS is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2014
    Posts
    17
    Orange
    Thank for your Respond.
    I solved It.
    The problem that I did not solved is the Following
    I try to use Dsum Function to sum the Gross Total for specific Customer from a SubForm

    My formula is Dsum("Gross_Total","Invoice-Header","CustomerNo=????
    CustomerNo is text Field
    The form is [FRM-Invoices-Details]
    Can you Help me??
    Thanks

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,850
    Show us your tables and relationships as jpg.
    Show us sql view of you queries.

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

Similar Threads

  1. how to rank using a query in acess 2007
    By BRAYAN RYAN VAN KYAN in forum Queries
    Replies: 1
    Last Post: 08-13-2013, 02:11 AM
  2. Unable to open the database in Acess 2007
    By Bhat59 in forum Access
    Replies: 1
    Last Post: 08-09-2012, 07:38 PM
  3. inserting into a SQL2005 db from Acess 2007 DB
    By macsterling in forum Queries
    Replies: 1
    Last Post: 11-28-2010, 09:12 AM
  4. Acess 2007 & SQL question
    By willigiann in forum Forms
    Replies: 3
    Last Post: 09-15-2010, 09:54 AM
  5. Acess 2007 Validation Problem- HELP!?
    By JackLowe in forum Access
    Replies: 1
    Last Post: 04-20-2009, 12: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
  •  
Other Forums: Microsoft Office Forums