RE: How do I correct erros from another program?

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hello. Thanks for your time. Both

But I'm affraid that my problem is a little bit more complicated and maybe
impossible to solve here in Access or my knowledge is not that good as
supposed to be. :) (and I like Access a lot. ok?)

Is just this. DISTINCT OR GROUP BY can help but there are some situations
here that are dificult.

My querie result on this:

Employee Data_GE Hora_GE Descricao
00001 03-01-2007 08:40 Entrada Torniquete 2
00001 03-01-2007 13:44 Saída Torniquete 2
00001 03-01-2007 13:45 Entrada Torniquete 2
00001 03-01-2007 13:45 Saída Torniquete 2
00001 03-01-2007 14:02 Entrada Torniquete 2
00001 03-01-2007 18:19 Saída Torniquete 2


Data_GE = Date
Hora_GE= Time
Descricao = Description


00001 03-01-2007 13:45 Entrada Torniquete 2
00001 03-01-2007 13:45 Saída Torniquete 2

This two records appear because sometimes the employee card system do not
open the doors at the first time, but the software register all the times
that the employee pass the the card, so sometimes the employee need to pass
the card more then once.

If you have any ideia, please help me.

Regards,
Marco



"Jerry Whittle" wrote:

This one is easy to fix! Put the word DISTINCT right after SELECT in the SQL
statement like so:

SELECT DISTINCT ......

OR

With the query in design view, go to View on the menu and select Totals.

Both should eliminate duplicates.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

"Marco" wrote:

Hello.

I'm creating a querie from another program. It register the time of each
employee get in and get out of work. But the machine that read cards and
register have problems, well it's not it's fault it'as just the way that it's
programed.

The problem is that sometimes the program reads twice the card and looks
like an employee enter and out at the same time. it can happens, but mostly
is the program that does that.

So what I want is to eliminate those record even if some good
register/recodset must be lost.

So I have this querie that returns this data:

-----------------------------------------------------------------------------
EmployeeNumber Date Time Discription
0001 15-05-07 08:00 In
0001 15-05-07 13:00 Out
0001 15-05-07 13:00 In
0001 15-05-07 13:00 Out
0001 15-05-07 14:00 Int
0001 15-05-07 17:00 Out

How do I remove those two extra records/register at 13:00h?

Regards,
Marco
.

Relevant Pages

  • Re: MAYDAY 2008
    ... mentioned in the Constitution with regard to citizenship and voting), ... out the card, ask me to sign it, and ask me to take it over to the machine ... for the purposes of the Electoral Register. ... A current electoral identity card. ...
    (alt.usage.english)
  • ALSA CA0106 regression: no sound with SB Audigy LS and kernel 2.6.18
    ... With all previous kernels I used this card worked fine. ... Register 00: 0000 ... subname: subdevice #0 ...
    (Linux-Kernel)
  • Re: Search for Tenants in Block of Flats
    ... So are politicians and civil servants, usually anxious to cover up their mistakes and pecadilloes. ... have to have passports and if I remember rightly passprts don't have our ... On the Continent I believe that you can be asked to produce an ID card - ... Likewise if you register with an employment agency you have to show your ...
    (soc.genealogy.britain)
  • Re: Search for Tenants in Block of Flats
    ... > Nick wrote: ... >> don't have to have passports and if I remember rightly passprts don't ... >> presenting a credit card. ... >>> The centralised civil register, ...
    (soc.genealogy.britain)
  • Re: Train passengers gassed by gang
    ... Coast the bikes would have to go in the space by the guards cabin and I'd ... alternate between sides of the train. ... get their identity from the Oyster card number. ... Just to be clear on this - it is only necessary to register an Oyster ...
    (uk.railway)