Search Result

Collapse
2 results in 0.0040 seconds.
Keywords
Members
Tags
querys
  •  
  • AlexMwells
    started a topic SQL Advanced Query Outputting to Excel
    in Access

    SQL Advanced Query Outputting to Excel

    Hi,

    I'm using the following code to find the total sales of each product to each customer, for a user choosen month.

    Code:
    SELECT HistoryHeader.DelAddress01 as Shop, HistoryLines.Description, Sum(HistoryLines.DiscountAmount) AS TotalQty
FROM CustomerMaster INNER JOIN (HistoryHeader INNER JOIN HistoryLines ON HistoryHeader.DocumentNumber=HistoryLines.DocumentNumber) ON CustomerMaster.CustomerCode=HistoryHeader.CustomerCode
    ...
    See more | Go to post
    • Clubsandwich
      started a topic How to Edit or manipulate tables using a button in the GUI (code issue)
      in Access

      How to Edit or manipulate tables using a button in the GUI (code issue)

      I'm trying to create a button on my GUI that will access a table or query I have created elsewhere and change all of the values of one field to "off".
      I use this application to create reports based on the options I select but need to reset them occasionally with out resetting the whole form to its original state.

      The only code I have tried so far is;

      Code:
          For Each Value In Table.Table1.Selected
      ...
      See more | Go to post
      Previous template Next
      Working...