Search results

Hi All. I have a db table of vendors for City and County. The vendor number is 8 characters for City (78945612) and 9 for County (the 9th is a "P" - 78945612P). I need a query that will find all dupe vendor numbers (first 8 characters) regardless of the "P". Will someone please help?? Thanks!!!

Hi All. I am working in Access 2003. I am importing a text file (import.txt) and saving specifications. Once I get the txt file imported, I run the following queries: 1. cRQs in N,A,P Status (Yr End) 1 CONVERT dates (within the txt file) Converts the text dates to mm/dd/yyyy 2. cRQs in...

:( Hello All! I am (unfortunately) working in Office 97. I have an Access report that I need to export into Excel. This report has groupings, totals, and percentages. It has about 850 pages. The query the report pulls from has about 35,460 rows. When I export the report, I get "There are too...