Search results

Hi, Are there any updates with regard to the performance issue above? Thanks

Hi, Solved the problem. However the performance issue still exists. I am wondering if this is access default performance behavior?? Running access to process queries (12 queries) simultaneously seems too much for it to handle as the queries are querying huge dataset. When I close and...

Hi, I received the following error for the second subroutine when I commented off the (ON Error Resume Next) statement. Error: Run-time error '429' Activex component can't create object Any idea how to solve this?

Hi all, I am doing running some queries in ms access and output the results to ms excel spreadsheet. There are several subroutines that I run when I click on a button on the form in ms access to trigger the process. Occassionally, when I run my the routines, ms access runs for some and left...

Hi, thanks for all the suggestions so far, I was wondering if the this would be a simpler and direct way of obtaining the desired result. I decided to use a DSUM function but have yet to get it work. The logic is to adopt your "Between" statement and sum up the figure. E.g: date is between...

Hi James, Yes, it is cumulative total that I am looking at. How do I got it to total up incrementally according to date? You mentioned table, how do I populate that? I will need a query to total the values up. Refer to my 1st post, you can see that the figure are added up.

Hi, I have tried Group By Created Date. It still doesnt give me the cumulative result that I am looking for. Are there any other solutions to the problem?

Hi, I have worked out the following query but do not know how to take it forward. TRANSFORM Count(OBSale.saleCount) AS VolCount SELECT OBSale[BGrp] FROM OBSale WHERE OBSale[Created Date] Between Format("1/9/2009","m/dd/yyyy") And Format(Date(),"m/dd/yyyy") GROUP BY OBSale[BGrp] PIVOT...

Hi, I would like to sum the values across dates similar to a DSum effect. This is my current data: I would like the values to sum up according to the dates Desired result: How to I write my query to achieve the desired result? Thanks for the help guys.

Hi, I am trying to replicate the process of importing excel file into ms access as a table. Is there any way of doing it?? Currently, I am manually getting it done via External Data--> Import Excel Spreadsheet. What I would like to achieve is to have a macro whereby a click of a button will...

Hi jzwp22, Thank you for the reply. However, I still encountered the same problem when I add additional clauses such as a WHERE statement. The results returned does not contain all the ProdtType. E.g: SELECT qryProducts.ProdtType, IIf(IsNull([Cost]),0,[Cost]) AS PeriodCost FROM qryProducts...

Hi, I would like to make my query such that it will always return all result, with the result that did not match the criteria to be set to zero. How do I do that?? Below is an example: I have the following table: ProdtID|ProdtType|Cost|MauType|DatePurc P001|Stationary|2000|15/1/2010...

Hi, I have the following query and would like to be able to control the pivot statement through two parameters. Tentatively, I have put 1 and 21 for testing purposes and would like to replace it with variables once I got it working. TRANSFORM Nz(Count(Case_ID),0) AS CountOfCase_ID SELECT...