Search results

  1. I

    Running a DB without spending £300

    I am trying to write an Job/Invoicing system specific to my job (as a Chauffeur) and a couple of associates of mine have expressed an interest in using it themselves . If I give them a copy of it do they have to spend £300 on a copy of access to run it or is there a cheaper way of allowing them...
  2. I

    Deleted records

    If you have a table with a field formatted as an AUTONUMBER and you delete say records 3,5,7 from an total of say 23, is there a way to reuse the deleted record numbers. I know that if you say delete record 24 and before you create 25 you can COMPACT and REPAIR DATABASE to reuse 24
  3. I

    Beginning & Enddates not dis correctly

    Can anyone help I have a field called JOBDATE (formatted as a shortdate, 00/00/0000). ! have records with the following dates 01/01/2001 01/02/2001 01/03/2001 and 05/04/2001. In the criteria field I have the following Between [Beginningmonth] And [Endingmonth] . When I run the Query with the...
  4. I

    Dates

    I have 3 fields in a form called Jobdate,Invdate & Reccashbydate. If the 1st date is input by me as say 13/01/2002 (but could be any day in the month) is there a calculation that will automatically input the Invdate as the 1st of the following month and Reccashbydate as the 1st of the month...
  5. I

    Display only Selected Fields in a Report

    In a report called COSTS (that runs from a Query called COSTS I have 4 fields - CLIENTCOST,DRVCOST,SUBSCOST & COMMCOST. Is there a way ,when I run the report, that I can have displayed a box? that allows me to specify which fields I want printed. If there is, can the report (say in the report...
  6. I

    Start/End Time Calc

    If you have a Start time field and an End time field (24hr clock) can you calc to another field the hours spent
Back
Top Bottom