Step through multi-line query response?

[Recordsetclown]

I posted this a week or so ago but got no response, so I apologize to anyone experiencing deja vu.

I have a report that duplicates a paper form having a number of check boxes. The report is based on a query of two tables related one to many that returns information for a single record id number. I'm using iif logic to check the appropriate boxes on the form based on a field value [response] from the query. That works fine so long as only one query line is returned, but more than one [response] may be present and anything after the first query response line is ignored by the report. I put the entire report in the page header section thinking I don't want subsequent lines to result in separate pages.

I'm new to Access (2K by the way) so maybe I'm going about this all wrong. Any ideas would be appreciated.

Thanks in advance.

Jeff

 

[RSi2]

explain a lite bit more what you wanna do ... i may be able to help

 

[RSi2]

explain a litte bit more what you wanna do ... i may be able to help

 

[Recordsetclown]

OK, I want to automatically generate a replica of a printed form based on information contained in two tables that are related one to many by a common field [RequestNumber]. This response form will have one instance of [RequestNumber],[RequestorName],[RequestDate],[DateReceived]and [ItemsRequested] and may (or not) have more than one instance each of [Response], [Comment] and [ResponseDate](although the response is decided once so each date would be the same) from the child table. The [ItemsRequested] field is just freeform text and the multiple responses would be to account for the possibility of different answers to parts A, B and C, if the request was phrased in that manner. Those answers might be Approved, Approved in Part, Denied as Exempt, Does Not Exist, and so on, for each of which a different checkbox exists on the response form. I was thinking to use the [Comment] field for explanation as to which part applied to each checkbox used where more than one response line exists.

The query that the report is based on will return a line for each record in the child table (the master table fields are the same on each line) but the report itself only responds to whatever is reflected in the first line. I'm looking for a way to automatically check and comment three or four boxes if there are three or four different lines in the query response.

Does this help?

Jeff

 

[RSi2]

if the data is not confidential, i think the fastest way is to send my a (striped)copy of your .mdb file (zipped) to rsi2@yahoo.fr
Post smth, if you have send the file

 

[Guest_imported]

Where can you write if/then statements in an access report and what is the correct format to follow when writing these statements in ACCESS? Additionally, my query produces records where the first line at a certain time is a master record, whereas the row underneath (next 1 to 10 rows) are responses to that master record. I'm trying to seperate them so that I can show the master record once in bold and then underneath keep the responses in a normal font. Thanks.

-Oliver
(301) 978-5301