Hello All, I am running a pool league and I am trying to create a query to show each player's record vs other players. By the same token, each team's record...

Hello, I have a first query which creates a base list from which I then base a second query (the one I'm having trouble with) which does a basic count which...

I'm using Microsoft Access 2007. I have a table with this field : Dealership Names Here are some examples of the values in the field... Honda of...

Hi there. Using Access 01 on XP. A coworker sent me a question and other than saying she needs to index her tables I'm not sure what to advise. Can someone...

Suppose a query with Field A and A1, A2, … are its values; Field B and B1, B2, … In a record, A1 could be associated with B1 and with B3 in another...

I am using a 2003-structure db file, necessary due to the need to keep user-level security on the db, and a query that uses distinct that worked fine when...

I have a downloaded table in which each item (primary key) has four date fields in mmm-yyy format. Each date field has a corresponding quantity field...

I want to create a report to track open assignments. My thought was to create a completed date control on my form and run a report showing all records that...

I have an age field that is calculated from a birthdate. I want to count the number of records in age groups such as 10-19, 20-29, 30-39, 40-49. the...

I'm trying to build a where clause, in VB, that refers to a field in a subquery of a query. The field in the subquery is not exposed. I cannot expose the...

Hi Everyone, I have 2 sub tables that are foreign key related (Reg No). I need to move data from one table (t1) to (t2), where both the Reg No and weekending...

Hi, A while back, I submitted the following post and was provided with a solution that worked. However, I now have an extra problem. I posted it but must...

Hello, My query asks two questions sequentially. It does an "Or" to find the result. How can I have both of the questions come up together so the user can...

I am using a parameter query to gather specific text data from a table to show in a report, and I know the text is in the table. If I request one string of...

I have a field in a query that multiplies 2 other fields and returns the answer. It looks like this in design mode: Freight: * This gives me the freight...

I have several Excel Spreadsheets linked in an Access DB that I want to combine into one table. All colunmn headers are identical in the Worksheets. Manually,...

Hi, I am slowly driving myself crazy... I am trying to assertain the sum of the weeks that our students have been on a course between 01/Aug/2007 and...

Hi All, I have userform in excel to search & get data from Access database. I need to update some values from excel to access. Right now i am using this...

I have a querie that returns based on a filed that is from10 to 20 characters in size. I want to limit the size to 10 characters left justified, but not hurt...

Hello, I'm building a query and the if statement was too long so I had to create a function with a select case statement. The problem I am having is with the...