Search results for query: *

Any ideas on what the problem might be in my calculations?

Forgive my choppy work, but im a lowly intern that tought myself enough access to cobble this db together. Transactions (Main Table) Fields: Ticket Number/Transaction Date/Counterparty/Type/Amount/Branch/Interest Rate/Value Date/Maturity Date This was then created to manipulate the entered...

I tried setting the field as primary key as well, no difference. While playing around with it I discovered that Regardless of the interest rate, if the counterparty and amount are identical, the resulting calculation will not count the second record's amount.

I just tried that. I simply added a transactionid field and it was autonumbered. The records had diff ids but the calculations still did not take into account the second amount.

I built a database that keeps track of bank deals transacted by a bank. I am new to access so when I created the database I set no primary key, in order to keep the db flexible as I was building/tweaking it. The current problem is that on occasion we have two deals on the same day for the same...

I am using the XP native utility, and I have tried my methods by typing the whole password out. Same results.

My wireless network has a WEp password, but whenever I try to log on to the network it reverts to an incorrect password. I have to delete and copy/paste the real one every time. I have tried deleting the network and adding a new one with the correct password, but it still reverts to the old...

All the data is stored in the Table, there is no problem with the recording of the data form the form. I apologize about the vague language. What I meant was that the records entered in the form are 'cleared' from the form, not the table. All data is intact. I would just like to know if it is...

I have a form that displays transactions made each day. the Problem is that whenever it is closed and opened again all the records entered in that day dissappear in the form. Is it possible to keep them up despite the from being closed?? If so if it is a shared db, is it possible for both...

That worked. Thank you

I have a sheet that is imported from and access query. This sheet will change depending on the data from access. The fields are: Date Amount 8/18/2004 ($17,020,966.67) 8/19/2004 ($90,789,680.01) 8/20/2004 ($395,559.34) 8/23/2004 ($13,782,879.05) 8/25/2004 ($27,531,708.33)...

PHV I took your advice and had the maturity query make the table, used the value query to append to the new table. Then I made a query to sort and sum the new table by date. I then created a macro to automate the whole process. That's exactly what I needed and it works perfectly, thank you very...

I want to display MaturityDateAmount with Maturity Date and ValueDateAmount with Value Date. Hope this clarifies things

Here is a sample of my query: Maturity Date|MaturityDateAmount|Value Date|ValueDateAmount |8/19/2004|($85,260,778.63) |8/12/2004| ($85,260,778.63) |8/16/2004|($27,004,440.00) |8/12/2004| ($27,004,440.00) |8/16/2004|($7,301,192.33) |8/12/2004| ($7,301,192.33) |8/26/2004|($1,000,525.00)...

This is all in a query called 'cashflow calculations' which uses the interest and the amount to calculate the cashflow. And just a note, you misread the field due to formatting. It is 'Maturity Date' and 'Amount.' I have all this information on a table, I just don't know how to make a report...

Here is the type of data my database contains, I am a newbie so I don't really know how to approach this problem Counterparty ValueDate Maturity Date Amount Cashflow BankA 8/9/04 8/10/04 $100 -$110 BankB 8/9/04 8/10/04 -$200 $220 BankC...

Here is a sample of what the data looks like. Counterparty ValueDate Maturity Date Amount Cashflow BankA 8/9/04 8/10/04 $100 -$110 BankB 8/9/04 8/10/04 -$200 $220 BankC 8/10/04 8/11/04 $300 -$330 BankD 8/10/04...

I have a query with these particular fields that are of interest to me: CounterParty, Amount, interest, Value Date, Maturity Date, & Cashflow(Amount * Interest) I need to be able to generate a 30 day report outlining the the positive and negative cashflow for each day. On the Value date, I...

Thanks for the advice, I have learned my lesson and I have made a backup. I immediately just rebuilt my form since all my queries were intact. It took almost all day but It's back up and running. Thank you for the advice though.

ANother thing: When I try to look at the VBA code for the form a mssg box pops up twice saying, "You canceled the precious operation