I need help with something i want to accomplish in a report.
I have a main table that all the info is based on.
I need to write a huge if statement because i don't have time to normalize the data.
The if statement is going to a create a record in a temp table if the field is not null. Then i want the report to display the temp table. it needs to do this per record. so i think it should first query the main record do a sub query print then delete the temp table.
I am new to access report builder, however I have experience with oracle forms and reports.
-Thanks.
I have a main table that all the info is based on.
I need to write a huge if statement because i don't have time to normalize the data.
The if statement is going to a create a record in a temp table if the field is not null. Then i want the report to display the temp table. it needs to do this per record. so i think it should first query the main record do a sub query print then delete the temp table.
I am new to access report builder, however I have experience with oracle forms and reports.
-Thanks.
