Search results

  1. D

    Form to input Criteria limits

    Using: Microsoft Access 2007 Setup: I have an Access 2007 database with a single table containing the following fields: Name Street City State ZIP Purchase Price Purchase Date (From and To) Item Amount Ship Date (From and To) Item Cost Purchase Code Store Code State Code I have created a...
  2. D

    Error on Report in Access 2003 but not 2007

    I created a report for a Crosstab Query based on the instructions provided by Microsoft knowledge base. I have no problem running this report in Access 2007 but when I try to run it in Access 2003 I get this error: "The expression On Open you entered as the event property setting producted the...
  3. D

    Help with dividing one row by another

    I have a database that tracks sales calls. Each time a sales person leaves a voicemail, receives a call back, speaks to a customer or sets up an appointment a record is created. (i've attached a document with sample data) My dilemma lies in that I need to report by week and I need to be able...
  4. D

    Test for Unchecked Checkbox in a query

    Hello! I have a form that allows users to check boxes to select the Reports they would like to run. The checkboxes are named as follows: chkReport1 chkReport2 chkReport3 chkReport4 I wrote a Macro that works perfectly to run the reports if the check box is selected. (there is a run button...
Back
Top Bottom