Hi and thanks for any help, I created a query based on 2 tables and for some reason i have duplicate rows. What is the cleanest way to delete duplicate rows?...

I have a table that has a number of fields in which there could be entries from 1-11. also each participant has multiple rows for data entry (which was an...

I have 1 table with ~217k records, 6 fields (Site_id, Date, parameter, value, remark, value_orig). Data in the value field are text strings, but are...

I have a tblWarranties containing multiple entries for each customer. I would like to return a record set of only the oldest ExpDate(s) for each customer. It...

I have a table that gets replaced each month with new data from a feed, no problem. I need to insert into this this table once the new values are there, the...

I have table with two fields. One field is number and other one refrence codes. Number of rows for a given number varies. I want to convert table to a query...

I think this is a relationship issue!! I have one table (t_customers) with years of data. I needed to create a form linked to that "t_customers". So, I...

Hello, I have an application where I need to generate sequential number in the range 1-99999. I have a table which will have one column storing these...

Suppose that I have a table that holds survey results. The survey has 10 questions, each with 3 results (say A, B, C). The survey is given out at different...

I have a set of queries which each has 6 or 7 fields. They are being exported to the same spreadsheet but one query is throwing up this error.

Is it possible to get the results of my crosstable into a make table? TRANSFORM Count(qTop3_Dates.) AS SELECT qTop3_Dates.Hospital, qTop3_Dates.,...

I have a table with 5 fields ID PersonID Date Amount and Type I want a query with the last record of each person based on date and I want the results like...

I have the following field titled Path as part of a full query, that has the following format of data, each row in the same format but different...

I have a table containing several Projects, Areas (where project takes place) and projects Phases. I made a query that Counts the total of projects in each...

....I'm sure it's possible. I have a table that shows each month of the year. During each month one person is assigned to complete a certain # of reviews...

Hi, I have a form that has a few fields that cannot accept a duplicate value. Can anyone tell me what coding or command I can put in the "After Update"...

I have a table that changes daily and contains 2 fields: ID(unique value), Score(with a range of 20 to 200) I want to be able to choose the maximum number of...

I need to multiply records according to the field. HOW!?

Hello This seems simple I but cannot figure out how to make it work. I am trying to make a query with 2 columns. 'Record ID' and 'Reference Record...

Okay, I tried reading the other average posts, and I still can't figure out what to do. The database I am using tracks when various lots were received, when...