|
 |
access thread: Print report having condition
Message #1 by "Enzo Zaragoza" <enzaux@g...> on Fri, 16 Nov 2001 18:36:49 +0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_00CB_01C16ECD.A7249C70
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hello!
The record source of my report is tblOrders. Now I want to create a
report only those "ActualShipDate" equals to nothing. How will I put
the coding on the print button?
I have Tried:
DoCmd.OpenReport "rptOrders", acPreview, , [ActualShipDate] =3D ""
is this correct?
Please help. Thanks,
enzo
Message #2 by "Pardee, Roy E" <roy.e.pardee@l...> on Fri, 16 Nov 2001 07:14:51 -0800
|
|
I believe that last bit has to be a string--check the help file.
I think the condition you want to impose is that the ActualShipDate is
Null--this is actually different from "" (commonly called an 'empty
string'). So you want to use something like
"ActualShipDate IS NULL"
for that last parameter.
HTH,
-Roy
Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Friday, November 16, 2001 2:37 AM
To: Access
Subject: [access] Print report having condition
Hello!
The record source of my report is tblOrders. Now I want to create a report
only those "ActualShipDate" equals to nothing. How will I put the coding on
the print button?
I have Tried:
DoCmd.OpenReport "rptOrders", acPreview, , [ActualShipDate] = ""
is this correct?
Please help. Thanks,
enzo
Message #3 by "enz@u... on Fri, 16 Nov 2001 23:32:42 +0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0084_01C16EF6.FD1645B0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
thanks Roy! just figured it out!
Enzo :)
----- Original Message -----
From: Pardee, Roy E
To: Access
Sent: Friday, November 16, 2001 11:14 PM
Subject: [access] RE: Print report having condition
I believe that last bit has to be a string--check the help file.
I think the condition you want to impose is that the ActualShipDate is
Null--this is actually different from "" (commonly called an 'empty
string'). So you want to use something like
"ActualShipDate IS NULL"
for that last parameter.
HTH,
-Roy
Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Friday, November 16, 2001 2:37 AM
To: Access
Subject: [access] Print report having condition
Hello!
The record source of my report is tblOrders. Now I want to create a
report
only those "ActualShipDate" equals to nothing. How will I put the
coding on
the print button?
I have Tried:
DoCmd.OpenReport "rptOrders", acPreview, , [ActualShipDate] =3D ""
is this correct?
Please help. Thanks,
enzo
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
|
|
|
View Cart
