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

I have a table with date fields and . I would like for the query to show me only the calls that have no date (are null) or if the date is greater than one...

Hi, I have a table that has multiple rows for person, each with a different admission date. What need to do is to build some a query that will identify the...

Dear Helpful users, As a Newbie to ACC2000 I have created a dB for our Service Dept where we record Customer details in one table and Repair details in...

Hi ; I use the forms function to record information into a table . There is a primary key defined for one of the fields that allows me not to input duplicate...

I can't see anything wrong with the following StrSQL string but I get this error: Run-time error "3134': Syntax error in INSERT INTO statement. Here's the...

I am matching 2 tables. I need to retrieve the records that do not match.

Hi all, I've got a union query that requires 2 parameters. I'm using vb6 to make a select statement based on this query but i don't know how to pass...

Our business uses the SQL based Sage business system. I have written a large number of queries on the Sage SQL database tables using the ODBC link to Access....

Here is the SQL for the two queries: Access: SELECT DISTINCTROW Delivery.Promised_Date, Customer.Name, Job.Part_Number, Delivery.Promised_Quantity,...

Anyone know of an easier way to convert a 4-length string to a beginning date (in my case 06/01/(XXXX-1) ) and ending date (in my case 05/31/XXXX). XXXX Is...

I have a SQL database that I have an external data link to an access database. I need to search records based on the current date. The problem is that the...

I am trying to delete records from an external database using a SQL IN clause, but my syntax is obviously flawed. My code looks like this: DELETE * FROM...

Hi All, I have a database with 3 tables: TBL_Persons; TBL_Absence; TBL_AbsenceReasons. When a person is absent I put a record in the TBL_Absence with the...

I have a table that I am trying to match up the Last Name, First Name, and Date of Birth to another table . I have created join properties for those three...

Hi I'm compiling a simple database to analyse responses to a questionnaire, most of which are multiple choice responses. I need to be able to have queries...

I've made a function that would calculate only business dates between current data and a date field (Nxt Cpn Dt). I've used the function dhCountWorkdaysA in...

I have 3 tables I am trying to join in a query. They are as follows: tblProducts tblCustomerEquipment tblEmployees In SQL Server, this query would produce...

Is it possible using SQL in Access to copy all the data in TableB into TableA? If so, could someone please post the SQL to do so? Thanks in advance.

Ok, I have been away from Access for a couple years now and was only a moderate user to begin with. I am trying to build a database in 2007 that has several...