Missing data in Access reports

Preston Davis

unread,

Nov 5, 2009, 4:26:01 PM11/5/09

to

I have several diffrent reports that I run, each off there own query. On a
few reports there will be a line or several lines of data that does not
appear on the report.

The database has records stored in multible tables. Records are based on a
property address from one table and linked to a 'Quantities' table that have
40 or so materials listed.

Trouble with one such report is that the query should pull all material
quatities for each proerty record. Trouble is that one specific quantity
field does not display on the report. But when I run a report for just the
one quantity it will show up.

I've examined the query closely and see no obvious

--
Preston

Jeff Boyce

unread,

Nov 5, 2009, 5:48:06 PM11/5/09

to

If there's a question, I missed it.

If you'll post the SQL of your query, and a description of the table
structure you're using, folks here might be able to offer ideas.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Preston Davis" <Presto...@discussions.microsoft.com> wrote in message
news:943F2645-8392-4A58...@microsoft.com...

KARL DEWEY

unread,

Nov 5, 2009, 5:53:02 PM11/5/09

to

Post the query SQL by opening in design view, click on VIEW - SQL View,
highlight all, copy, and paste in a post.
--
Build a little, test a little.

Preston Davis

unread,

Nov 6, 2009, 12:04:05 PM11/6/09

to

SELECT tblProperties.PropertyID, tblProperties.[Prop Cord],
tblProperties.Year, tblProperties.[Street Num], tblProperties.[Street Name],
tblDetails.DetailType, tblDetails.DetailNote, tblDetails.DetailValue,
tblDetails.[DetailY/N], [Street Num] & " " & [Street Name] AS Address,
tblTypes.Group
FROM tblTypes INNER JOIN (tblProperties INNER JOIN tblDetails ON
tblProperties.PropertyID = tblDetails.PropertyID) ON tblTypes.Type =
tblDetails.DetailType
WHERE (((tblProperties.[Prop Cord]) Like [Forms]![PropertyMain]![PickCoor] &
"*") AND ((tblProperties.Year)=[Forms]![PropertyMain]![PickYear]) AND
((tblDetails.DetailValue)>0) AND ((tblTypes.Group)="Quantities"));

--
Preston

KARL DEWEY

unread,

Nov 9, 2009, 11:14:01 AM11/9/09

to

Try this --

SELECT tblProperties.PropertyID, tblProperties.[Prop Cord],
tblProperties.Year, tblProperties.[Street Num], tblProperties.[Street Name],
tblDetails.DetailType, tblDetails.DetailNote, tblDetails.DetailValue,
tblDetails.[DetailY/N], [Street Num] & " " & [Street Name] AS Address,
tblTypes.Group

FROM tblTypes LEFT JOIN (tblProperties LEFT JOIN tblDetails ON

tblProperties.PropertyID = tblDetails.PropertyID) ON tblTypes.Type =
tblDetails.DetailType
WHERE (((tblProperties.[Prop Cord]) Like [Forms]![PropertyMain]![PickCoor] &
"*") AND ((tblProperties.Year)=[Forms]![PropertyMain]![PickYear]) AND
((tblDetails.DetailValue)>0) AND ((tblTypes.Group)="Quantities"));
--

Preston Davis

unread,

Nov 9, 2009, 7:10:02 PM11/9/09

to

I discovered the error, it was in the database table.

Thank you for the help.

Jeff Boyce

unread,

Nov 10, 2009, 12:53:18 PM11/10/09

to

If you'll post back what you found, it could help others when they have a
similar issue.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Preston Davis" <Presto...@discussions.microsoft.com> wrote in message

news:D3767DB8-A5D7-4C15...@microsoft.com...