Re: Appointment Time Falls In

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Larry Linson (bouncer_at_localhost.not)
Date: 03/28/04 

Date: Sat, 27 Mar 2004 22:21:54 -0600

It is really unlikely that anyone can help unless you describe in some
detail how you've set up the tables to hold your data. Without that
information, any "solution" would just be a guess.

  Larry Linson
  Microsoft Access MVP

"Stephen" <steph_mw@hotmail.com> wrote in message
news:40650240@news.comindico.com.au...
> I have a database that is an appoitment book for some sales reps. They
enter
> the date, time of the appointment and the duration that the quote should
> take. The finsih time is calculated by using the Dataadd feature (thanks
Van
> T. Dinh). But I need to be able to show the user if a sales rep already
has
> an appointment for this time period.
>
> e.g.
> Appointment_Date Sales_Rep Appointment_time
> Duration
> 27/03/04 Dave 09:00 AM
> 2 Hours
> 27/03/04 Jim 09:00 AM
> 45 mins
> 27/03/04 Steve 09:45 AM
> 30 mins
>
> User tries to insert a job for Dave at 10 AM for 30 minutes. Can anyone
help
> me with this. ANy help would be appreciated.
>
> TIA
> Stephen
>
>
>

Relevant Pages

  • Appointment Time Falls In
    ... I have a database that is an appoitment book for some sales reps. ... time of the appointment and the duration that the quote should ... an appointment for this time period. ...
    (microsoft.public.access.forms)
  • Re: Calculating time without using time functions...
    ... I want to run the sheet on my mobile phone as it can run simple sheets but ... totals by entering the hours and minutes in separate columns. ... Start Mins B1=20 ... Duration Mins B3=B2-B1 ...
    (microsoft.public.excel.worksheet.functions)
  • Setting appointment duration with IAppointment
    ... I have tried setting the duration property in several different ways, ... appointment is always set to the current time and the duration is set ... // Create a pointer to the CDOEX Appointment interface. ... IAppointmentPtr iAppointment); ...
    (microsoft.public.exchange.development)
  • Re: Merge Switch Question
    ... When a user sets up an appointment it is done via ... this as a duration in hours and minuets e.g. "2h 45m" but apparently ... figure out how to devise a suitable switch to format this number ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Comparing dates problem
    ... decrement the display to show something like the following: ... 10 minutes past your appointment ... def pluralise: ... mins, secs = divmod ...
    (comp.lang.python)