I have a looming report deadline, and suddenly a query I thought I had fixed shows me it's not fixed. In the SQL below, please please PLEASE look at...

Hi everyone! Using A02 on XP. Need to give my boss some info and my brain cannot figure out how in the 2 hours left before her meeting. I have a table with...

I have a query which shows 2 fields. It counts the how many of each status has occured in the database. eg. Withdrawn 2, Issued permit 53, Sent back 5 etc. ...

First, let me say I know this has been asked and answered many, many times. I have tried out several of the solutions given, and can't seem to make it work...

last night my colleague messed up big time, and one of the table has had it's data overwritten to one value. ie: i have 3 tables, one for the booking, one...

HELLO IFEANYI COULD YOU PLEASE CONTACT RICHARD McKAY AT PENMENS LAW FIRM AT 205-207 SARACEN STREET, GLASGOW, G22 5TQ. THIS IS AN URGENT MATTER YOURS...

I messed up the message below! apologies for that. Is it possible to take out duplicates in an SQL for a union query. In my database I have information on...

hi everyone i am using db to enter patients info and expenses.now my boss asked me to create a report based on ages like this( for diagnosis and...

New at query writing. I have the following two tables that I need to search for users that are defined to the same connects. Using the following...

I need some urgent help with quarter field I have 3 columns in my database OrderNo, OrderData, OrderAmount say that the date right now is Jan 07 then I...

While trying to access my Database, I'm getting the following error " The Microsoft Jet Database Engine could not find the object 'MSysDb'. Make sure the...

I have a customer table and a transaction table. and i need to find which customer ids are in the customer table but not in the transaction table -- Message...

I have two table and I need to merge the results The first table contains all the name of products (description, weight, etc.) that I had to show The second...

My assignment's due date is approaching. I'm nervous now! How can I build this sql statement in a function: SELECT LAST(fieldName) FROM (SELECT TOP p PERCENT...

Hi, I really need help - this formula is ticking me off! Well, here's the expression: TotalBill: IIf( Is Not Null,((+(IIf( Is Not Null,,0)))-(IIF(Is...

Please help. I have a form with mulitple fields (status 1, status 2, status 3) which can contain one of four criteria (open, pending, closed, cancelled). I...

Hi all, I dont know if anyone can help but I have been given some data to deal with and unfortunately it's in a text format, I have a date that looks like...

I have to following Access2003 Code that needs to run in SQL 2000 SELECT extend, Source, Count(PersonalID) AS RecordCount, Count(IIf(0,(),Null))...

I have three tables; tblsalesrep, tblclients, tblgeneral. tblclients references tblsalesrep to show what salesrep is assigned to that particular client,...