Displaying stats on main menu form

[Lloyd]

I have a Main Menu form that opens when the user opens the database. It has
7 Dlookup fields (Here is one example:" =("Murders YTD: " &
DCount("[personcasetype]","qryytdmurdervictims")") that I use to show the
enduser current stats based on records in the tables. The database is split
with the backend on a server and the front end on the users local PC. The
problem is there is a delay on the Main Menu form while it does the DLookup
calculations. I want to still display the stats for the user but I need to
speed up the calculations. Is there a way to have these done on the server
instead or any other way to speed them up.?

 

[Noëlla Gabriël]

Hi,

have you tried to make a totals query to get the results, and use this query
as a data source for your form?

 

[Lloyd]

there are a number of calculations needed to bring back the final number.
Wouldnt a query on the front end do the same thing as a Dcount and have to
query the whole table to do the calculation?

Hi,

have you tried to make a totals query to get the results, and use this query
as a data source for your form?


--
Kind regards
Noëlla

I have a Main Menu form that opens when the user opens the database. It has
7 Dlookup fields (Here is one example:" =("Murders YTD: " &
DCount("[personcasetype]","qryytdmurdervictims")") that I use to show the
enduser current stats based on records in the tables. The database is split
with the backend on a server and the front end on the users local PC. The
problem is there is a delay on the Main Menu form while it does the DLookup
calculations. I want to still display the stats for the user but I need to
speed up the calculations. Is there a way to have these done on the server
instead or any other way to speed them up.?