Search results

  1. A

    Access VBA runs and stop suddenly

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

    Summing across dates - Query Help

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

    Macro to automate the process of importing a excel sheet into access

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

    Query that return a fixed set of results and format

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

    Crosstab Pivot from parameters

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