I have some several fields that have duplicate Patient_ID and I would like to count those duplicates and assign them a number for example. Patient_ID...

I have a database ASJ that contains scores by individual within age groups. I rank the scores by individual from low to high for each agegroup. I need to...

Good Morning Scenario: Record Table User Table For example: 852 Records need to be assigned equally among 4 Users and displayed in a report/form in User...

I need to assign sequence numbers in multiples of 10 to a BOM file that I am creating. I have the following information in a current table: ITEM ...

Hi I need to assign sequential numbers to a field to some records in a table. I am opening a recordset and assigning the numbers as follows; Sub...

Hi I need to assign sequential invoice numbers to orders starting from the last highest number + 1. I have tried the following code; UPDATE Orders SET...

In quering a sales database, if the sales amount is positive how do I get the query to add "Sale" in another field or if the sales is negative have it add...

Hi, I have a table that lists authors by 2 fieds (last name and first name) among other information, like journal title, etc. What I need to do is assign a...

Everyone - I have a query where I'm pulling a set of records. I want to assaign a sequential number to each of those records. I know that I need to use...

I would like to assign two users to a database. One for general use where users would log into the database as read only and the other as an admin user that...

Hi, I run a query based on an invoice table that calculates how many hours the staff members have worked. Every week, the person who enters the invoices...

How do I write a function in a query that assigns values 1,2, so on to an empty field? Thanks in advance

I need to calculate the total cost of room hire and catering. To book the catering I have a table which contains all of the options that can be selected,...

Windows XP Pro SP2, Access 2003 I have a query containing (among other fields) the fields: fldName (text), fldID (number), fldPrimary (yes/no field), and...

Hi, I have Access 2000, and when I created a query in my computer, the query automatically adds the asterisk (*) to the end of the query design in SQL view,...

When specifying all fields in a table in a select statement does it make much difference whether one uses the asterisk for all fields or is it more acceptable...

Hi all. Here is my dilemma, I have a table with either one or two asterix in a column (the same column). One asterix signifies a different outcome than...

I have a table where i keep mission information. i am trying to build a query to pull the date (for date specific info), the type of aircraft, and the...

Here is part of my query (a column from the query builder window).. ChildsLocation: (SELECT "(" & IIf( Like "Resident*",IIf(IsNull(),,),) & ")" FROM...

Hello everyone. I am trying to run a query with an imbedded subquery but continue to get the error "At most one record can be returned from this...