Search results

I know this is simple, but having brain cloud. I have a query for BranchCd, CustNo, and InvoiceNo. I have created a query to get the count of invoiceNo for each BranchCd, and CustNo. Now I want to pick the BranchCd with the highest count for each CustNo. I have tried using the max...

I have two tables, one table “Data” has member(SUBSCRIBER_ID) data including service rep(UserName). Another table “ServCoord” has data including service rep and their manager. What I am trying to do is pull 5 random accounts per service rep. I can pull 5 random accounts, but not per service...

I have a very simple query I would like to update. Both tables have primary keys, I am able to update both tables. I used to be able to do this in previous version. This is just a very simple query. I get results, but cannot update. SELECT Test.Med_no, Test.Quest1, Test.Quest2, Test.empDate...

Currently using Access 2007-2010. I have a text file that I am trying to import into Access. I am having issues with the time fields. I need to be able to sum them in a query or report. When I import it in, Access is put the 12:00:00 am as default and adding numbers to achieve the 11...