Search results

  1. A

    Calculating between fields in a table and the sorting

    Dear MStef, I want to: 1. sorting the ascending & decreasing in percent and in absolute value between any 02 dates that I want. Ex: I want sort between today and yesterday, or today and the last week, or today and the last month 2. I don't know how to put date criteria in my query, despite of...
  2. A

    Calculating between fields in a table and the sorting

    Sorry MStef, I don't see different between between 02 table that you sent to me. Let me explain more detail my problem: I want to compare between any 02 days in my database. If I input the Monday of this week and the last week -> the query will compare price between a week. If I input today...
  3. A

    Calculating between fields in a table and the sorting

    Criteria the certain day Could you help me to do the query that input 02 days and then compare between 02 days instead of the first day and the last day. I try to put Date criteria in the First and Last field to find out the percentage change between any day, but I can't. Could you help me...
  4. A

    Linking data to word

    Hi all, I have a situation here and want to find the best solution. Everyday I have to do a report about stock market. The figures I take out from my database, and I do my commend in word 2007. I want my word document template automatically link the data from Access database, so I just have to...
  5. A

    Calculating between fields in a table and the sorting

    Below is an example of my table "Pricedata" include 03 fields: Stock Name ___Price________Status Date A________________10________ __1/6/2008_ A________________11___________1/7/2008_ A________________12___________1/8/2008__ B________________22___________1/6/2008_...
  6. A

    Problem convert from MySQL to Access

    Dear all, My company uses SQL DB to manage and run website. My department decided to use Acess database for internal using so we transferred the SQL DB to Access DB. I'm facing a problem that the tables and relationships look like very strange, different from what I know about AccessDB. Let me...
Back
Top Bottom