Recent content by emblic

Thanks Rich, I hope I'm not asking a realy stupid question but I need to get this done. What do you mean by combining the fields? Also where can I change the font and size for certain sections of my report.

Sorry IMO, Rich is right. Say for exaple I have 60 records related to Global Funds and another 50 related to Domestic Funds. What I then want are those records 60 records for Global to be grouped on one page and the 50 for Domestic on another, totalling 2 pages. As I have it now, the 60 is...

Hi OMO, I don't want to print each record on a seperate page. I want related records on one page ie I have written a database monitoring investment returns of asset managers over time. Investment Funds have different mandates or can be categorized into eg Global and Domestic. What I want is...

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.

Sorry Jon, My db looks bit different to the one I posted here on the forum. I had to adapt it because it is large. I corrected the query to the db posted here. Like I said it is a bit slow(so far i have 11000 records) but it works. I think it will only work in some instances ie when the...

Jon you are my HERO!!! Although it was a simple syntax thing in the end it would have taken days for me to figure ot out. This forum really kicks ... Anyway I took it a step further and my index works. Only thing is that it is a bit slow. My code: Index...

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

I do that each time I delete records. I restructured some of my tables and knocked off some space.;) But it is still huge. I'll spend some time 2day and maybe I'll get something worthwile out there.

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

Thanks Neil, I sorted out the mismatch error - had to change the fundid form text to number. I'm attaching the database just for any recommendations from your side. Any data contained so far is just for testing purposes.

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