Search results

Using Access 2003, have query that sorts by last name and first name correctly. The report that was designed using the query won't show the name (first or last) if it is a duplicate. The report sort/group box has the name fields. The table is indexed and allows duplicates. Any suggestions...

I now need help with a report. My last post was in the query section related to joining several queries and getting the correct result. By the way BrianWarnock, I am taking your advice on the look up field in the table and removing it. I had read the pros and cons about this on several sites and...

Taking advice from another post, have created 4 different queries, named Qtr1, Qtr2, Qtr3 and Qtr4. Need help with getting correct results. Want Qtr1 to be the sum of ConAmt where dates > =1/1/2009 and <=3/31/2009. If I can get help with Qtr1, I can do the others. Fields included in all queries...