Search results
-
H
Query Question
[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... -
H
European Date Stored in DB
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... -
H
Query Problem
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... -
H
Text Box recalculates when pressed
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... -
H
Query question
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)... -
H
Switching a subforms view from "form" to "datasheet"
[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...