Search results

I have a query in my database that provides me with all the records I want on my report. My report must: Display all the records in certain categories(this I sorted out making use of the wizard), but I would like to limit each category to one page. The problem here is that I find difficulty...

Hi, I have a query which takes quite a while to run and do its thing (on my original data) Is there a way of overcoming this? What I mean is: What must I do for the query to use only the latest data which was entered and not do its computations each and every time that it is run.

I'm trying to build a database which keeps track of investment funds over time. At the end of each month the follwing info is captured: FundName, Date, Return - these are the most important. I have follwing tables: FundName(Name,id), Date(Date,id), FundData(lookup FundName,lookup Date...

Ok, I'm on my way. My data is normalized and just as i thought things are going good, things got bad again. I'm busy creating a form to enter data. Most of my fiels have type number(double) and set to percentage. My problem is: the person capturing the data won't divide each value by 100 to...

Hi all, Problem Statement: I want to compile a database that monitors the returns and other information of investment funds over time. Each month data about each fund is entered into the database. To determine the layout I used the following method: I captured all the data I need in an...

Hi all, Problem Statement: I want to compile a database that monitors the returns and other information of investment funds over time. Each month data about each fund is entered into the database. To determine the layout I used the following method: I captured all the data I need in an...

Hi all, Ok here it goes. I've been working on this database on and off the last two months but run into walls the whole time. I've got a feeling that it actually is simple but my problem lies at the very beginning in defining my tables and relationships. I can't decide between having a flat...