Report View or prinpreview

**phatus** · 11-07-2010, 09:45 PM

sir i have a search button in my Form here working fine connected to my query...

example.. isearch only district 2 all district data will only appear... but it appear in spreadsheet view...
how can i make it done in report preview?

here is the code ni my search button

in Clear Button

Private Sub Command33_Click()

Me.qdistrict = ""
Me.Requery

End Sub

and in search button

Private Sub Command34_Click()

DoCmd.OpenQuery "Masterlist Query", acViewNormal

End Sub

the result.. if you search a specific district it will appear in spreadsheet view...
how can i make it appear in a report preview or report view?

**alansidman** · 11-07-2010, 11:30 PM

You must build/design a report in the report builder and use the query or table as the record source. Queries will alway open as a data sheet view except when you specify a pivot table. Reports must be built separately.

Alan

**phatus** · 11-08-2010, 02:06 AM

@alansidman
do you mean i make another table for district 1 only and make a report on it? and do the same for district 2,3 and 4?...

im not fin transferring now if that will be the procedure ill update 2 table the same time....

any suggestion sir?

here's what i tried...
i make a query and my source is my main table, but my problem is all the district are included..i dunno how to make a query the only district 1 shows.... coz im thinking of making 4 query, query1 for district 1, query2 for district 2 and so on and make a report in each query.... i cant find the hide button where in i want to try to hide the information....

**alansidman** · 11-08-2010, 07:30 AM

You do not need to build another table. Use the report wizard found on the ribbon under create. It is a good place to start. As your record source use a query. Either one you already have or create a new one.

Read about reports here first:

http://www.techonthenet.com/access/reports/index.php
and here
http://www.mstipsandtricks.com/tips-...s/reports.html
and here
http://msdn.microsoft.com/en-us/libr...ice.12%29.aspx

As to your question on different districts, use a parameter in your query. Read about them in the above.