Toukey-
First, fix your table design. You need a table that looks something like this:
ClientNo
DocumentNo
Response (yes/no)
Comment
DocumentNo would be linked to a table that has each document description and selected with a combo box. It would be easy to produce a report selecting just the "no" records.
This has two additional advantages:
1) Data doesn't have to be saved for any documents that don't apply
2) If documents need to be added or removed in future, you simply add or delete rows in the Documents table rather than have to redesign your form or report.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Apr 25, 2014, at 3:35 PM, toukey1 <no_reply@yahoogroups.com> wrote:
I have a form with a client field, 15 yes/no fields (which represents if certain documents are submitted or not) and a comment field for each yes/no field. I need to produce a report displaying the client name where the yes/no field = "no" and also display the comment. For examply, a client may have submitted 10 out of the 15 required documents. I would like the report to display the client, the documents that were not submitted along with the comments.
How do I accomplish this?
Regards
Toukey
__._,_.___
Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar