RE: Records Missing from Report

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

I think you've hit on the answer, Jerry. My query was built on another query
which had multiple joins and one didn't have the right properties. Thanks so
much!!!

"Jerry Whittle" wrote:

To add to Karl's questions, are there more than one table joined in the
query? Often it's just a case of an inner join between tables with one not
having a matching record.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"MarshaM" wrote:

Some of my records do not flow over to the query result or report. They do
not have any special filter and the query does not rule them out. It seems
random as I cannot find 1 specific commonality between these records that
would differentiate them from the ones that show. They are imported from the
same application as the records that show. I have +7,000 records. Any
suggestions?
.

Relevant Pages

  • RE: Update Query Parameter Values
    ... Thanks Jerry, the update query is working properly now. ... "Jerry Whittle" wrote: ... The query runs fine until I view it in design view. ...
    (microsoft.public.access.queries)
  • Re: Automate Query
    ... Thanks very much for your prompt response, Jerry. ... Now IF the database is open and IF the form is open, the query should be ... exported to a spreadsheet somewhere between 4am and 5am every morning. ... Keith Bontrager - Bicycle Builder. ...
    (microsoft.public.access.queries)
  • Re: Join Query Expression
    ... Thanks to the both of you, Jerry and John, with your help the query is now ... "John Spencer" wrote: ... If they work then you can build a query along the lines of Jerry ... "GMD" wrote: ...
    (microsoft.public.access.queries)
  • Re: Different MSSQL output date format from the same PHP script
    ... Please don't delete attributions; ... Jerry suggested no such thing. ... So you're using the database as a persistence layer for your ... You wouldn't want to ever want to, say, run a query returning all ...
    (comp.lang.php)
  • RE: Error when trying to save a query
    ... Thanks so much for the advice Jerry. ... Dim TheTier As String ... Yet another option is to make a simpler query, ... INNER JOIN tblWeeks ON AND ...
    (microsoft.public.access.queries)