Yes, 2 of the 4 fields in the query are memo fields! I checked some of the dates in questions and they have a lot of characters in them. Any suggestions?
And by the way, I checked every date in 2004. The dates that hang up are 6/10/2004, 9/9, 11/9, 11/16, 11/30, 8/6, 8/25, 8/30 and 2/19. The date field is a Date/Time datatype so there could not be invalid date formats in the field.
Unfortunately, neither methods worked. I also tried to "analyze" the table performance and the wizard added an index to the date field. That did not help either. There are only 2400 records in the .mdb. I also tried importing the database to a new database on my hard drive instead of the server...
I have a simple report based on a query. There are 4 fields from one table. No joins. The two criteria is: 1-Date Range and 2-Owner. There are 3 "users" of the database. When I run the report for 2 of the 3 users for 2004, the report runs perfectly. When the report is run for the 3rd user, the...
Hello:
I am trying to figure out how to print an Access Report to 4 network printers in one click. I am assuming I could code a command button, but I don't have a VBA book. Any suggestions.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.