Re: Conflicting Record Problems

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

Hi,

The table in question is called absence:

Absence #
Staff #
Reason (Text Field with value list combo box) A/L, Sick Leave, Special,
Study etc
Leave Date
Return Date
Hours Missed

As I mentioned we have an index to prevent staff leaving twice on the same
day however it is possible for them to return twice on a particular day.
This is the only prevention we have.

Ian

"Nick Coe (UK)" wrote:

> Need more specific info on your table design to be able to
> offer any more suggestions.
>
> --
> Nick Coe (UK)
> http://www.alphacos.co.uk/ AccHelp + pAnimal
> http://www.pjandcoe.co.uk/ Online Store
> http://www.mrcomputersltd.com/ Repairs Upgrades
>
> In news:C1362351-18B0-4791-AAD2-0489E25B2038@xxxxxxxxxxxxx,
> NoviceIan typed:
> > I'm not getting anywhere I keep getting Invalid Syntax
> > message.
> > How would I prevent the problem in future?
> >
> > "Nick Coe (UK)" wrote:
> >
> >> Depending upon how you've designed your tables you could
> >> use
> >> a Select query to show the records where Holiday and Sick
> >> are both Not Null. Or some variation thereof.
> >>
> >> Exactly how you do it depends, as I said , on your table
> >> design i.e. what fields you use, how you distinguish
> >> between
> >> Holiday or Sick and so on.
> >>
> >> I suspect you probably have a start date and an end date
> >> for
> >> the leave period and then a field to show what type of
> >> leave
> >> it is and that's how people are managing to enter
> >> overlapping periods. If this is the case then start
> >> thinking about criteria and table aliases.
> >>
> >> Open a query design grid, drop in the table you want
> >> TWICE.
> >> The second instance of the table is known as an alias.
> >>
> >> Now, assuming the table design above, drag the start date
> >> and end date from BOTH of the tables down into the grid.
> >> Make sure the tables are not joined.
> >> In the criteria for the start date of tbl2 put
> >> =>tbl1.startdate and run it to see if it works. Then add
> >> a
> >> criteria for tbl2.enddate of <=tbl1.enddate.
> >>
> >> I'm making this up as I go along <g> so you'll likely
> >> need
> >> to mess around with it...
> >>
> >> HTH
> >> --
> >> Nick Coe (UK)
> >> http://www.alphacos.co.uk/ AccHelp + pAnimal
> >> http://www.pjandcoe.co.uk/ Online Store
> >> http://www.mrcomputersltd.com/ Repairs Upgrades
> >>
> >> In
> >> news:B57FF1A0-1213-4D1C-8AA5-BF27A3AF7D59@xxxxxxxxxxxxx,
> >> NoviceIan typed:
> >>> Hi,
> >>>
> >>> We have a staff database which we use to try and keep
> >>> track of
> >>> staff leave. Recently however I've noticed that staff
> >>> have
> >>> been booked in for two different reasons at the same
> >>> time.
> >>> For example annual leave from the 10th-17th and sick
> >>> leave
> >>> from the 12th-14.
> >>>
> >>> We have an index which prevents staff having duplicates
> >>> for
> >>> the same leave day however we've just realised there is
> >>> no
> >>> security to prevent the above problem happening.
> >>>
> >>> How would I prevent these 'problems' and how will I
> >>> detect
> >>> the
> >>> ones already in the system?
> >>>
> >>> Ian
>
>
>
.

Relevant Pages

  • Re: Milling with a drill press
    ... At my last place of employment, just before I started my machine shop ... through a job, leaving enough time to do it twice if necessary, instead ... When doing prototype design work it is a waste of time to spend ... I had "no bid" the job, ...
    (rec.crafts.metalworking)
  • Re: Milling with a drill press
    ... At my last place of employment, just before I started my machine shop ... through a job, leaving enough time to do it twice if necessary, instead ... When doing prototype design work it is a waste of time to spend ... I had "no bid" the job, ...
    (rec.crafts.metalworking)
  • Re: Milling with a drill press
    ... At my last place of employment, just before I started my machine shop ... through a job, leaving enough time to do it twice if necessary, instead ... When doing prototype design work it is a waste of time to spend ... I had "no bid" the job, ...
    (rec.crafts.metalworking)
  • Re: Sparc ethernet interface
    ... It's an amazing design, and they can be had for a song ... Of course, but it takes twice the memory, twice the processors, six times the number of internal drives in the chassis, about twice the number of PCI cards, and three power supplies instead of two. ... They're wonderful racks. ... I've gotten them in that price range several times. ...
    (comp.sys.sun.hardware)
  • Re: Conflicting Record Problems
    ... "Nick Coe " wrote: ... > thinking about criteria and table aliases. ... > Open a query design grid, drop in the table you want TWICE. ... >> staff leave. ...
    (microsoft.public.access.modulesdaovba)