I have a split database and started having problems after a new better faster server was installed. But I can't totally blame the server because when I relocate the main table 'tbl_Sample_Login' on to another network location/drive my personal drive H: then I get the same problem!!!
I rebuilt the query one field parameter at a time and ran itagainst the back end. All resultsreturned quickly UNTIL I added the most important parameter and that was thedate range to get the last 7 days of the rest of the stuff.
However when I use a WHERE statement on my short date format...
"WHERE(((tbl_Sample_Login_table.LoginDate)=Dat e()-7))"
(where I want to get the subset of records that are from thepast 7 days only). BTW, the fieldLoginDate is a short date format.
It seems to me as though the query itself in Access frontend is put together, converted to sql, or something at the front end Accessprogram. Is there some setting perhapsthat I could have jacked up with Access?