Recent content by Dsquad

Thanks for the help Pat.. I went through the process explained on the MS site.. It more applies to actual table navigation and not database navigation. All of the databases have identical structure. I just want to be able to somehow change which DSN the access database points to via some sort...

Where do I go to get: Q128878 - ACC How to Create a Customized Attach ODBC Table Form

ummm Can you link where to go ? (sorry new to these)

My company has multi locations that each go under a different business name. Thus, we maintain 7 different databases on a single SQL server. The SQL databases are identical in design.. I have written various reports that are identical for each company (except for heading info etc, etc). The...

In the control source? =Nz(fieldname,0) ?????

Totally agree I have been working the same issue.. I am trying to calculate the SUM of a couple different queries and when there is no data within it, it just turns everything blank on the report... IE: =[sub_total]+[TAX] If there was no TAX then it shows a blank as the total... HELP HELP HELP