Search results for query: *

Thanks for the reply... Answer to your first question is: there is this Poisson formula available in Excel not available in Access. Thats the reason I am using Excel. And thanks for the tip thats exactly what I did and found that it worked perfectly. Appreciate your patience.

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.

thanks ..it worked like a charm...:)

I just checked that it opens the file and that particular worksheet but it does not input the value into the Excel worksheet objSheet.Cells(2,9).Value = Me.txtAvgCCS When i check in the Debug mode : me.txtAvgCCS has a value = 0.1 but that value is not input in Excel that means the above...

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

will try it..thanks

Well my prob is like this , I have the following data : Month Dept MaxSalary April HR 100 April Payroll 60 April Admin 80 So I have this query which I created where for every month for every dept what was the max salary given. Now the thing is...

it works .....this has been very useful Chaz. Appreciate it..

Thanks a ton...will let you know if it worked...

Thanks for the answer will try it.

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