I'm having trouble getting an Iif Statement that includes a Dlookup to work. Here is what I have but the records where the Iif is true show nothing for this...

Dears While we making a query by using query wizard' there is a option to get sum,min ,max,avg in summary option if the data is in number type. Any body can...

Could someone assist with the following? I am getting errors! Sum(IIf() = (), ()-()) AS Thanks,

Hi All, I have 12 columns representing 12 months usage. I wanted to create a 13 column and use the AVG function. AVG_SOLD: AVG(++++ +++++ ++) I get an error...

I have a column of 5 digit julian dates (ex 08066) that I need to convert to a calender date. The julian date is formatted as text. I am using access 2003. I...

How do you join multiple Select Statements, here is what I would like to join; SELECT Count(SCD.Status) AS FROM SCD WHERE (SCD.Assigned)="Carla" and WHERE...

Hi, I've got my duplicates records query and now I want to delete these 1100 dups in my table of 12,000+ records. Can you please explain how I can easily...

I have a tabel with 2 fields. I have created a query where I count all records per year and per month based on the field 'Open date'. SELECT Year() AS Year,...

Hi All, Following a tip I got from the forum yesterday, I want to find a way to make it easy to find redundant queries in my database, prior to deleting...

To whom it may confuse. I have a query with a text field that needs to be sorted in descending order. The field name is "ContainerNumber" and the data will...

Hi, I am currently writing a stores inventory database and have nearly completed it except for one issue. When a stock take is carried out the user...

Hi All, I have a query that I am trying to use to return names and addresses that match partial(match half or more character)or full to another field. And...

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 table with record. Each record has an opening date and most records have a closing time. What I would like is to see a pivot table or chart where I...

Hello, I want to list some specific queries in another query. The queries that I want are prefixed by a 99 but when put 99 in the criteria of the first...

Hello All I have been wrestling for ages now with a query that I thought would be simple .. but can't get the output I want! I have a table with fields...

I have 3 "TYPES" of duplicates. Here is the table: ID classID Attend_date 1 625 12/13/06 1 292 5/16/006 2 244 (empty/null) 2 ...

Basically i have a drop down that i want controlling the Criteria for each field in my query to have an advanced search. If i leave a field blank the query...

I'm running a Find Duplicate Query to find the instances of two values in selected records. Each record has a unique identifier, then a field for Condition(A)...

Can anyone help me with this problem, I have been trying umpteen different ways of doing this with SQL (Which I don't entirely understand...) I want to merge...