Search results for query: *

Another way, if the records are entirely identical, is to use a simple SQL command: select distinct * into (new table name) from (old table name); Then, simply delete the old table and rename the new one.

You can also export it to snapshot format. (.SNP), this will save all of the graphics and formatting. However, the user may need to download the free viewer from Microsoft to open it.

Thanks, again for the help, Frank!

Is that field a decimal format? If so, Access 97 won't recognize it. Change it to double or long.

Thanks! Using your code, I was able to see what I was doing wrong. I've made the changes and it works fine. If you have time, could you take one more look my code? In the following code, I know that all those If statements aren't necessary and that I should just be able to do it in a loop of...

Thanks for replying! The control to be changed, the textbox on the report (or one of them, anyway) is 1_year. What I was trying (and failing :) ) to do was to compare the value of 1_year on the report to the date range specified by the sdate and edate fields in the table tbldaterange. The...

I have two tables in my Access 2K db: tblData, and tblDateRange. TblData's colums are made up of fname and lname columns, and then a series of dates. My query pulls all of the rows from the tblData where any of the date columns fall between the two dates listed in the tblDateRange table...