Search results for query: *

I have an excel sheet which is calculating some value based on some value sent by access. Sometimes in the Excel sheet you can have a #value if there is no result. Now if Excel returns a #value how do i trap it in Access..Any help is appreciated.

I am trying to open an existing Excel file from an Access and trying to send it a value and based on some calculations it returns some value back to Access which i need to display in the report. the problem is when i am trying to open the excel file it does not open it . My code is as follows...

Can you add another query to a report which has already been designed? I have already created a group by query and created a report on it. But now I need to add a field to it which is based on another query how do i go about doing it. Thanks in advance.

I have created a query where I have to group records on the basis of week and some other fields. My problem is when i group it on the basis of week using Datepart(wk) functionality it returns the number 13 for example for the last week of March and the same number appears in the report as its...