Recent content by access man

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

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

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

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

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_...

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