Filtered Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

Please help me in the following
I need a fitered report.
I have a table, one of the field in the table i have my serial number, the
number is in this form( TWP/1001/2004 ,TWP/1002/2004, TWP/1200/2004
,TWP/1250/200 etc..

the report should filter on base my input, for example if I type "TWP/10"
then it should show all the records which starts with this series, if i type
"TWP/12" then the report should show all the records which starts with this
series, it should not include any other series

In order to get that i tried with a query and a form. The form has a text
field where I will type the series, bu i could not get the reult. In MsExcel,
we can fiter "Begins with" can we do the same in Access

Please help
 
Hi,
If I understand you correctly, you should be able to use "like TWP/10*" to
get your results.
Your report will call the query and the query will use your input as criteria.
Something like this:

select * from Table1 where serialnumber like [forms]![myform]![myinput] & "*"

Hope this helps.
 
Back
Top