Recent content by haydenbl

Found the answer.

That just returns one row. I need the top branch code for each customer.

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 tried making one or both a primary key and that does not work either. I know this should not be that difficult. Thanks for all the ideas. Any more would be greatly appriecated.

Attached is a simple version of my database.

The query is at the very top. It is not linking to another query, just to the two tables.

I want to be able to use this query with a form. Basically I have two tables, 1 tables has all the member information in it and the other table has the questionnaire information in it. I want to use the query for a form and have the med_no the same between the two tables and have them see the...

It tells me that the query is not updatable.

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...