Here is the deal is is about 25 different field names. We are pulling this
information from a form with checkboxes. So we are wanting to hide those
items when they have not been checked during a certain time frame.
Here is the SQL you requested the items I am wanting to hide if zero start
with AIS omitted and end at Delivery\Summ of Prov omitted. Please let me
know if you need any more information.
Thanks for the help
SELECT [Employee Team tbl].Team, [Error Detail tbl].[Person Creating Error],
[Error Detail tbl].[Today's Date], [Error Detail tbl].[Variance Date], [Error
Detail tbl].Worktype, [Error Detail tbl].System, [Error Detail tbl].[Policy
Number], [Error Detail tbl].[AIS omitted], [Error Detail tbl].[AIS
incorrect], [Error Detail tbl].Amendment, [Error Detail tbl].[AWD misc],
[Error Detail tbl].[AWD Pol Print], [Error Detail tbl].[AWD Pol Print exam],
[Error Detail tbl].[AWD transaction not created], [Error Detail tbl].[AWD
Comments incorrect/incomplete], [Error Detail tbl].[AWD CSD Incorrect],
[Error Detail tbl].[AWD Surf for Sources], [Error Detail tbl].[AWD Notes Not
Followed], [Error Detail tbl].[AWD Push Case], [Error Detail tbl].[Procedural
rules], [Error Detail tbl].[AWD MVR/IR Transaction], [Error Detail
tbl].Underwriting, [Error Detail tbl].[EnCorr letter], [Error Detail
tbl].Agent, [Error Detail tbl].[Companion Not Issued], [Error Detail
tbl].[Pull Labs], [Error Detail tbl].Reissue, [Error Detail tbl].Reprint,
[Error Detail tbl].[Update Mainframe], [Error Detail tbl].[Wrong Policy
Scheme], [Error Detail tbl].Replacement, [Error Detail tbl].Requirement,
[Error Detail tbl].[Entry Incorrect], [Error Detail tbl].[Cash Incorrect],
[Error Detail tbl].[Illustration Wrong], [Error Detail tbl].[Form Incorrect],
[Error Detail tbl].Other, [Error Detail tbl].[Delivery\Summ of Prov omitted],
[Error Detail tbl].Comment, [Error Detail tbl].[Other details], [Error Detail
tbl].[No Errors], [Error Detail tbl].[Person Reporting Error]
FROM [Error Detail tbl] INNER JOIN [Employee Team tbl] ON [Error Detail
tbl].[Person Creating Error] = [Employee Team tbl].Name
WHERE ((([Employee Team tbl].Team)=[Forms]![QR Reports form]![Team Selection
IDP]) AND (([Error Detail tbl].[Today's Date]) Between ([Forms]![QR Reports
form]![IAG Start Date]) And ([Forms]![QR Reports form]![IAG End Date])) AND
(([Error Detail tbl].[Person Reporting Error]) Like "QR*"))
ORDER BY [Error Detail tbl].[Person Creating Error];
Ofer Cohen said:
No it shouldn't make any different.
Can post the SQL you have now and the name of the field?
--
Good Luck
BS"D
EHOWE said:
I tried this and got an error message. I am basing my report on a query, does
that make a difference?
:
You can a criteria to the report record source not to display zero values in
the report
Select * From TableName Where FieldName <> 0
--
Good Luck
BS"D
:
I forgot what I am getting after enter the If statement is this
87 87
7 7
:
I have a report where I am listing about 25 items. I would like the items
that are 0 to not show, which I am doing by =Iif([fieldname]=0,"",[field
name]). The problem I am running into is instead of showing the label it is
showing the number twice. This is what my report originally looked like:
No errors 87
Agent 0
Policy 7
What I would like it to look like is this:
No errors 87
Policy 7
Thanks in advance
