Hello all,
Does anyone have any code that will subtotal a query in Access?
Thank you.
BEFORE:
Account Code Principal Income
4 BUY $10.00 $0.00
4 BUY $10.00 $0.00
4 BUY $10.00 $0.00
4 BUY $10.00 $0.00
5 BUY $10.00 $0.00
5 BUY $10.00 $0.00
5 BUY $10.00 $0.00
5 BUY $10.00 $0.00
5 BUY $10.00 $0.00
4 Sell $5.00 $613.89
4 Sell...
eskelies
Last Activity: Mar 31 '08, 08:30 PM
Joined: May 17 '07
Location:
-
Subtotal in queries using Access 2003
-
AD,
The code works great!
Again I thank you! -
Thanks man I appreciate it!Leave a comment:
-
Table1:
Date AccountNum 1 2 3 7 8 9
12/31/9999 20 3% 3.01% 3% 3.17% 3.12%
New Table:
Date AccountNum Class Num Percent
12/31/9999 20 1 3%
12/31/9999 ...Leave a comment:
-
AD,
I hope I understand your question. Each fund number should have multiple classes (ie. 1,2,3,7,8,9) to be exact. Each Class will have a percent associated with that. As far as field date is concerned I am going to ultimately have two tables. One for current date and the other prior date. I will need these dates because I will be building queries off these.
Hope this helps!Leave a comment:
-
Here are a few issues I know of:
• Interrupted write operation
• Faulty networking hardware
• Opening and saving the .mdb file in another program
• Mismatched Versions of the Jet Database Engine
• multi-user access
• Inefficient database design...Leave a comment:
-
Transposing Data Tables...Need Help!
I have a sanitized database which I have attached, and for the most part transposes the data to my liking. There is however a few issues that I would like to fix, but cannot determine the problem in my code. Basically, the text field AccountNumber is being recognized as data, along with the account numbers and classes being populated incorrectly. If you run the attachment you will see my error. I appreciate anyones help in this matter. Thank you.... -
That is exactly what I am looking for. I actually did it another way. I don't know what is easier, so I will compare them both. I just made a make table of all the queries I used and linked master/child fields.
I apprecaite all your help.Leave a comment:
-
Fish,
what I want to happen is take query Accrual yield Impact Final and query NAV impact summary (r086) and synchronize them. When I say synchronize them I mean the following:
I would like the user to beable to go into frmselectfund. Once they select their fund they will then beable to run a button macro (which i have not built) that will pull up another form. Let's call it test. This form needs to have both queries built...Leave a comment:
-
trying to upload database file.......Leave a comment:
-
Fish,
Sorry if my information is unclear. I thank you for taking the time to help me even though I am a pain in the butt. :)
Does a moderator have to give me the ability to attach files?...Leave a comment:
-
Form 3 can be either bound or unbounded. In this case, I have it being unbound.
I have some code in form 2, which is:
The subform control (form 2) has link master fields which is below. This protects my database from manual updated records.Code:Private Sub Form_Current() If Not Me.NewRecord Then RequeryAccount Number End If End Sub
My source Object is: query 2
...Leave a comment:
-
Fish,
Sorry...Let me try and explain better. I have two queries below, which I know are large:
I am doing analysis on the data that is represented in the two queries. I do not use all of the data when I build forms around them, instead I use certain fields which populate within the appropriate form. For instance, I use Account Number, prior contribution yield, est contribution yield, etc. in query 1. The same thing goes...Leave a comment:
-
Synchronizing two forms?
Hello all,
I have two forms, which are already synchronized, however, everytime I page to the next set of data both queries run again. This slows down my database to a point of unreponsiveness . Is there a way to speed up these forms from running over and over? -
Access Performance question...
I have several linked tables, with lots of data in them. I have several queries using all this data, which is slowing down the speed of my database. I tried using the "analyze" function in Access, but because my tables are linked no indexing can occur.
Does anyone have any tips to make my Database run faster? -
Okay...I'm an idiot. Thanks Rabbit for your help....Leave a comment:
-
In by doing this will it translate the date (ie. 1/14/2008...1/15/2008...etc.) into the string "Accrual Yield?"
Do you know where I might find an example?...Leave a comment:
-
Rabbit,
Will I need to do something like this?
[Code=sql]
UPDATE PRCJ830A_Crosst ab SET PRCJ830A_Crosst ab.[01/11/2008] = Replace([Accrual Yield])
WHERE PRCJ830A.[01/11/2008] ="Accrual Yield"
[/Code]...Leave a comment:
-
Crosstab query help...
Hello all,
I have a crosstab query that sets specific dates as field names. Is there an easy way to change the field name from date (numerical) to "Current date", but still give me the current dates information?
I am running access 2003 and below is my SQL code:
[Code=sql]
TRANSFORM First(PRCJ830A.[Accrual Rate]) AS [FirstOfAccrual Rate]
SELECT PRCJ830A.[Fund Number], IIf([Class] Is Null,0,[Class])... -
Unclear how to perform this action in Access. Help needed if possible.
Hello all. I am very new to this and I don't know if VBA is the better route to go.
First and foremost I am running Access 2003.
I have a table in my Access database. This table is made up of three fields. The first being Date. The second being Day of the Week (ie. Sunday, Monday, etc.) and the third being holiday/weekend. Under the column holiday/weekend I have inputted a "Y" if it is a weekend or holiday;...
No activity results to display
Leave a comment: