Recent content by ThePhantom

You have been most helpful..... By the time I got ur reply, I had done precisely what u have outlined..... I created an intermediate table based on my complex query, and now, I have to refer to only around 1000 records, rather than 0.5 million of them!!

Faster Querying?? Hi, I have a table having more than 500,000 records. I have created indexes on all the major fields..... However, MS Access only allows creating indexes on the columns themselves, rather their parts too..... What I mean is, I can create an index on PayDate, however, not on...

I acknowledge your point regarding the recordsets..... However, if I have 5 DLookUps on a single query, would not that query execute just once rather than 5 times?? Also, the reports are such that, a user selects month, year, department, etc. from a 'Report Menu' form, and then selects a report...

Complex Query Execution Hi, I have a table having more than 500,000 records. I have created indexes on all the major fields..... However, MS Access only allows creating indexes on the columns themselves, rather their parts too..... What I mean is, I can create an index on PayDate, however...

Hi, I have an aggregated report based on a GROUP BY query, which groups a numeric column called 'Lag' by Department, and then Division & Location..... However, I need an average value of this lag per department. Since, this value cannot be accomodated in the query, I created a text control and...

Hi, I have a form with a tab control having around 10 pages. Now each page has a subform creadted by clicking "Insert Subform", which is nothing but a form defined on a table to the main. My issue is that I want the subform to display only records corresponding to the value of an unbound combo...