Search results

Hi, I am having trouble extracting top 5 vendor with the sumOfSpend (actual Field name is Spend which is dis-aggregated) for each of 5 groups. Each group has thousands of transactions for dozens of vendors. The Table is designed as follow. Table1: GroupName : Text VendorName : Text Spend ...

Hi, I am trying to pass a recordset to a sub procedure as follows Private Sub AddNewSProdStatus(rsTemp As DAO.Recordset) rsSProdStatus.AddNew rsSProdStatus![ProdID] = Me.Recordset![ProdStatusID] rsSProdStatus![TitleID] = Me.Recordset![Title] rsSProdStatus![ProdDealType] = 1...

Hello, I would like to change the text formatting (color, italics, bold etc) of the contents of a control based on a boolean value in the underlying datasource of the report. For instance, I have a report that generates a "Proforma Invoice" i would like to ability italicize the prices of...

Hello, I am fairly new to Access and this forum has been very helpful. I have been struggling with combining multiple rows into one row for an order summary report. Specifically, I have three tables (Products, Orders, and OrderDetails) Products ======= ProductID = AutoNumber ProductName =...