Search results

  1. D

    Compare Query

    I have a table that we assign license numbers to and enter them in the table. Over the years many numbers have been missed and skipped. So I made a table that compares sequentially and then looks at the ones missing as the next number. The problem is they can begin with MB or MBB with a total of...
  2. D

    Question Push Button to increment, will add one to category

    I need to be able to push a button an add 1 to any number field, I may have 10 buttons, but I need it to show a count in the box and everytime you push the button it goes up one. I am using this to collect times of a particular event that It will total every month and reset to zero. So ineed...
  3. D

    report Query

    I have a query that runs fine in datasheet view but when attached to report it bombs. It has to be related to the expression field I put in to select to proper types from two different tables. (EXP1:) Hear is the code. SELECT Count(qryExamErrorsByDate.LicenseNum) AS CountOfLicenseNum...
  4. D

    Phone calls query

    I have a table that collects phonecalls by type, operator selects the particular type and the date. This table is all check boxes, so I count by day the number per item and total. I need this to give me all the months at the top with the count of the items below. there are 12 items to count...
  5. D

    I thought it was a simple report

    I have a report that I can't get the query to build correctly, I have had some help on already. I am not a programmer, but understand quite a bit with the databases. I need a query that will give me 3 columns that display total count for a month of list of 8 items and two additonal that are in...
Back
Top Bottom