Report/Query

[monbri]

I have two issues that I am trying to resolve.

1. How do I get only one record to display per page. My report is displaying up to three records per page.

2. Each record is sorted by a assignment number (LL0001012345). I want to create a query to pull up the record in a form using only the last five digits. How would I write the query.

Thanks in advance for anyone who can assist.

 

[Andrew Fergus]

Hi,

You can change the page breaks in your report as follows :

View the report in design mode, Click on the section where you want the page break (i.e. the detail section), Click View -> Properties -> Force New Page -> After Section. Save.

This will put one record onto each page in your report.

For the other part, you could use something like =Right([assignment number],5) in a query to look at the last 5 digits of the assignment number. {Remember to use your variable name}. In your query include the original assignment number and the short version. This query can then be used on the form in a dropdown / combo box.

HTH, Andrew.