Re: Find Missing Data

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Richard Thombs (richard.thombs_at_compositedata.com)
Date: 07/08/04 

Date: Wed, 07 Jul 2004 22:19:31 -0700

Is your payroll data coming from a SQL data source? If so, I would really
recommend constructing a query that pulls out the missing data. I realise
this might not be possible in your situation, but if it is, I think it
will be the easiest way.

Cheers,

Richard.

Relevant Pages

  • Re: Access Table Sorting/Query Last Function
    ... of the Lastin your totals query. ... I've been designing a database that basically works off two tables. ... the natural sort order of the table would insert new data to the ... in the query that pulls the information from the table. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: scripting / data problem.
    ... each one has some duplicates with less than complete info.) ... matching / missing data depending on file. ... that's just part of the query that contstructs a relationship across all ...
    (Ubuntu)
  • Re: Dropdown list maintenance in a dap
    ... a query that pulls the names, this query allows me to keep the list in ... "Sylvain Lafontaine" wrote: ... >> Gilles A Belanger ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Parameters in the query
    ... You must also declare the data types of any parameters in crosstab queries. ... > I have a Report that pulls from a Select Query, ... > CrossTab Queries, that both pull from the same Select Query, that pull ... > report can more easily display the needed information. ...
    (microsoft.public.access.queries)
  • Re: Parameters in the query
    ... The report's record source could have a criteria ... code below to the On Open event of the report. ... > When you say report's recordsource query, I assume you mean the query the ... > report pulls from? ...
    (microsoft.public.access.queries)