Trying to get certain data, if not avaliable then print N/A

[merlin72]

Access 97
I have a list of "Qac" codes and dates that are used to indicate what test were taken and when that particular test was taken. I want to be able to display who has taken a particular tests like QAC023332 and get the date he/she has taken it. I have it working , in queries ,where it shows what test were taken. But i would like it to show the " QAC" code and "N/A" for the date if that particular test was not taken.


Want Report to print:

John Doe

QAC023332 11/15/79
QAC023333 N/A

I think i might have to do this as a module with SQL.



Thanks In Advance.

 

[MichaelRed]

merlin,

You can use Nz within a query to set up an alternate output 'value' for the field (with a different field name). A module does not appear to be necessary.

Assume the date field in the report recordsourc is "QacDate", and the results of the processing will be "QacDateNew"

QacDateNew: Nz([QacDate], "N/A&quot

This is just "off the top", so you may need to explore the Nz function and syntax a little to get exactly what you want.


MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over

 

[merlin72]

I have a table that has the "QAC" ,"Description", and what area it is for.
Another table has the "Employee", "Date" and "QAC"

I would like to be able to first found out what test are for that particular area and then find out if they took the test. If test does not show up,then place "N/A" next to the "QAC" number. If test is there then place "Date" next to the "QAC" number.

Thanks In Advance.