Search results

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