S saqibawr Registered User. Local time Today, 07:17 Joined Oct 3, 2008 Messages 27 Oct 21, 2008 #1 What will be the VB coding for a report that it shows the records from a fields which value is greater then 1. Suppose i want to show fine in a report & i dont want to show the records with 0 fine.
What will be the VB coding for a report that it shows the records from a fields which value is greater then 1. Suppose i want to show fine in a report & i dont want to show the records with 0 fine.
boblarson Smeghead Local time Yesterday, 20:17 Joined Jan 12, 2001 Messages 32,059 Oct 21, 2008 #2 Well, let's say that your field name is FINE and your report name is rptFines You can open the report simply by using: DoCmd.OpenReport "rptFines", acViewPreview, , [Fine] > 1
Well, let's say that your field name is FINE and your report name is rptFines You can open the report simply by using: DoCmd.OpenReport "rptFines", acViewPreview, , [Fine] > 1
S saqibawr Registered User. Local time Today, 07:17 Joined Oct 3, 2008 Messages 27 Oct 21, 2008 #3 I sorted my problem thanks for your help.