Search results

Hi, I have an Access Macro (works in 2003 & 2007) which connects to external servers to download data and execute queries. It takes approximately 25 minutes for running all the pass-through queries and internal queries. When the connection is slow, I get an ODBC call failed error. I increased...

Hi, I have a query which takes an input from the user and gives required details for that quarter, like Week ending date, month, etc. When no quarter is selected, the query result is blank. I want to introduce a validation wherein the user is forced to enter a value, and blank value is not...

Hi, I have to create a select query (which I think is a bit complex). I have to retrieve Week, Year and month from a Master table. I find this simple. Apart from this I need to find the starting date of a particular month and last date of the particular month for the respective month. The...