Search results

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

Thanks very much for everyones help it is much appreciated to a beginner like me, perhaps I can avail on your experience and now ask the next question which is How would I then format a field (using those dates input formatted as YYYYMM) in a report to show these results but in the format of...

One of the reasons I asked, was that I thought it might be the best way of using a field for Audit Type purposes ie have a continuous set of numbers. perhaps now I know I can delete and then reintroduce the number I will have to think again. Many Thanks for your time

HTH I Have Tried this and I am certain I am Inputing it correctly One thing that does happen when I put the Format[JobDate] Seq in the field of the Query is that it forces Expr1: prior to the string I input. Apart from that when I say input JAN 2001 & JUN 2001 it reports JAN/JUN/JUL dates...

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

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

Thanks very much Harry Much Appreciated Ian

Brilliant Thanks But sorry for being stupid but I dont understand your last line.........Need to set the two........

Thanks for the route to go down I made a form up and then went to the 'On open' and it asks me on the event proceedure whether I want to build an expression, macro or visual basic. I presume I use VB but having never used it before I do not know where to start. Can any one recommend any book...

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

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

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