Search results

Try looking at the dcount function in help, It will count all the records from any table or query.

This will happen to a coworker also, each time he reboots the computer it fixes it, but it keeps coming back. This also happens in his Word and Excel. Access Reports already made with 1" margins will change to 6" margins only on his machine. It is Office 97 with Windows 95. No one can solve this...

Thanks.

This is solved with Office XP. Just right mouse click on the field and choose conditional formating. very easy and pretty slick. Unfortunatly, you must have Access XP though.

You have to index whatever unique field you have in the table to not allow duplicates (or maybe multiple fields), then they will automatically be deleted when you do the append query.

I would like to have a parameter query which propmts for a date, then return all dates less than or equal to the date you put in, or if you leave the prompt blank, return all records. I have tried something like this <= like [Enter Date] &"*" but it doesn't work, does any one know how...

Thanks, I will not be able to work on this for a couple of days. I will let you know results. Bill

I wonder if anyone can point me in the right direction. I want to export an Access report grouped by 49 different categories with Page breaks at each category. The hard part is I want each Category to go to a different worksheet in the same Excel Workbook. The users want it in excel to work with...