Search results

Thank you. Here is my SQL code. SELECT a.WBSKey, Sum(a.[Receipt amount]) AS SumReceipt, a.VendorName FROM JoinCardspendTNEFull AS a WHERE (((a.CLSNAME) Is Not Null) AND ((a.WbsKey) Not Like "[#]" And (a.WbsKey) In ("SB-1000085","SB-1000261","LO-1010525","LO-1003585","SB-1000307"))) AND...

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...

Got It !! Using Expressions in Conditional formatting ..

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...

Thanks it worked !!

I actually moved the function to the query below the form. I get the same error. ConcatRelated("[Products].ProductName","[Products]","[OrderProductDetails].OrderNumber =" & "[Orders].OrderID ") AS Expr1, I get the error. --------------------------- ConcatRelated()...

This is the error I get from report when I try to run it. --------------------------- ConcatRelated() --------------------------- Error 3061: Too few parameters. Expected 1. --------------------------- OK ---------------------------

Yes, the function you suggested. I am trying to use that as an expression in the report field. ConcatRelated("ProductName", "Products", "[Products]![ProductID]=" & "[QueryBuildOrdersAndProducts]![ProductNumber]") I hope this helps.

I have put that function in a module in my application. However, I am having trouble using it as I am not very familiar with how to use it. I have an INNER JOIN query which retrieves information for the report. I tried to embed that function in the query, but I keep getting the "Not enough...

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 =...