Re: Update query

From: mac_see (macsee_at_discussions.microsoft.com)
Date: 02/27/05 

Date: Sat, 26 Feb 2005 21:05:02 -0800

I am sorry, that was a typo. 1st Jan is the first 1st record in the lotto
table. Again a typo for your next two questions.

Can this be done somehow?

Maxi

"Duane Hookom" wrote:

> I'm not sure:
> -why you think Jan 1st is the 2nd record in the lotto table
> -how you matched 2 values since the first Check record
> matches 3 in the 1st Lotto record and 1 in the 2nd
> Have you considered normalizing these tables? You whould then be able to use
> joins in totals queries to count the common values.
>
> --
> Duane Hookom
> MS Access MVP

Relevant Pages

  • Re: Input from Form to Query
    ... > Fat fingers, typo in e-mail. ... >> Duane Hookom ... >> MS Access MVP ... >>> Dave ...
    (microsoft.public.access.queries)
  • Re: Update query
    ... normalizing your table structures. ... Duane Hookom ... Again a typo for your next two questions. ... >> MS Access MVP ...
    (microsoft.public.access.queries)
  • Re: Problem with linked forms
    ... MS Access MVP ... got it right fixing your typo!). ... "Duane Hookom" wrote: ...
    (microsoft.public.access.gettingstarted)
  • Re: Problem with linked forms
    ... You didn't fix my typo;-) ... Duane Hookom ... MS Access MVP ... The error message I get is ...
    (microsoft.public.access.gettingstarted)
  • Re: Totals for two fields
    ... I went over it a couple of times and it must have been a typo on my ... "Duane Hookom" wrote: ...
    (microsoft.public.access.reports)