Recent content by HedgeKAM

Haha, I was mistaken. The query is correct, im just using the wrong salesID! :)

[Solved] Query Question This is my current query: SELECT ClientID, FundID, Sum(Shares) AS SumShares FROM Transactions WHERE SalesID = 44 AND TradeDate < Format(#01/01/2004#,"mm/dd/yyyy") GROUP BY ClientID, FundID; The WHERE clause is causing a problem. Say a Client has 20 transactions in a...

My date fields in my db are stored in dd/mm/yyyy format. Using VBA I can manipulate it fine, but problems arise when doing things like this: SELECT * FROM Table1 WHERE EuroDate < #01/01/2004# Is there a way to format EuroDate with SQL? (Im doing this in a query, so I cant use VBA. Thanks in...

Yepp, I got it to work using grouping :) SELECT ClientID, FundID, Sum(Shares) AS SumCount FROM Transactions WHERE SalesID = 44 GROUP BY ClientID, FundID; I wanted to try to also include a JOIN in that SQL, but I cant get it to work. SELECT Transactions.ClientID, Funds.FundName, Sum(Shares)...

thanks, ill give it a shot :)

Hi, I have a Table that looks like this: Transactions ------------- SalesID ClientID FundID Basically a client will do a transaction. The transaction has a salesperson and the transaction is in a certain fund. What I want is for a given salesperson (SalesID) a list of that salespersons...

Thanks for the help! It doesnt work yet, but you have given me a few ideas of how it might be solved. Ill post if I find a solution :)

That would have worked if the Record Source of the subform was static, but it isnt :). I have another subform in the main form, each record in that subform has a button that changes the Record Source of the subform I am trying to do. If I have a OnLoad macro, it will only load the first time...

I know the form has a OnLoad event, but that wont help my problem. My subform is a continous form, showing a recordset. it has a Text Box in its Detail area. The Text Box's Control Source is a VBA function that returns a number. When the recordset is large, the subform will ex. have 100 of the...

no, its on the ControlSource of the Text Box. (=fncFundName([FundID])) There is no on load event on the text box?

I have a form that has a subform with lots of text boxes. The text boxes source is a VBA function that calculates some number. The problem is, each time I scroll the subform or click into one of the text boxes, it recalculates the numbers. This makes the form very slow and jerky. Is there a way...

Thanks for your response! I tried your SQL but it isnt selecting the funds distinctly. Im getting several of the same FundID :(

That code works perfectly :) Abit more: Private Sub button_Click() If button.Caption = "Datasheet view" Then Me.subformname.SetFocus DoCmd.RunCommand acCmdSubformDatasheet button.Caption = "Form view" Else Me.subformname.SetFocus DoCmd.RunCommand...

Hi, I have two tables that look like this: Transactions ------------- TransID ClientID SalesID FundID Funds ------------- FundID FundName a Client has many transactions in many Funds. Each transaction has a SalesID. I want to select distinctly what Funds (FundID) a Sales persons (SalesID)...

[Solved] Switching a subforms view from "form" to "datasheet" have a form with a subform. On the form I want a button that when pressed will change the subforms view to datasheet. Ive tried alot of things to no avail. Any Ideas? EDIT: A quick search in the forum and I found the same question...