Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Danglez

    Indentical Records that need differentiation

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

    Indentical Records that need differentiation

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

    Indentical Records that need differentiation

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

    Indentical Records that need differentiation

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

    Indentical Records that need differentiation

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

    WEP Network Key in Windows Wireless

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

    WEP Network Key in Windows Wireless

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

    how to prevent records from dispearing when form is closed

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

    how to prevent records from dispearing when form is closed

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

    Matching Amounts to Dates (EXCEL)

    That worked. Thank you
  11. Danglez

    Matching Amounts to Dates (EXCEL)

    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)...
  12. Danglez

    Making one date field out of two

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

    Making one date field out of two

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

    Making one date field out of two

    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)...
  15. Danglez

    30 Day Forecast Report---How do I go about ti

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

    30 Day Forecast Report---How do I go about ti

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

    Query Design: Using a date range and manipulating numbers

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

    Query Design: Using a date range and manipulating numbers

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

    Help, report and forma re locked and will not open or design

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

    Help, report and forma re locked and will not open or design

    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

Part and Inventory Search

Back
Top