Need some help. I have the below query that works well, except in the following situations. qryInsufficientStock SELECT tblOrderDetail.OrderID,...

Hi Access 2000 SP3. I have a Clients table which has 5400 records.When I run the below query to return all records in Clients table that have matching keys...

I have records that I need to assign an index to. This is what I want to end up with: Store # KO# End Index 472 13663 31-Jan-11 ...

Dear all access expert, Hi, I have problem with my project, which is as follow : Suppose I am a project manager and I have 10 technician. Each tech can be...

Hello everybody, I have the query: SELECT personen.Familienname, personen.Vorname, Diagnose, Evaldatum, perspflege2.lfd_nr FROM (perspflege2 INNER JOIN...

Hi Access 2000. I have started getting a 'Can not perform this action at this time' error on the line; DoCmd.OpenQuery "My Query" This app is running on a...

Hi. I have a query that uses two Combo Box in a form to set criteria in two different fields of a table. My problem is the query does not return any result....

I have a working query with the following calculation: Expr1: *** I want to improve the calculation in that when the is Null, the expression should...

I need to run a query for yearly numbers, for example, include all dates from December 22, 2007 through December 21, 2008 (Year needss to be reletive to the...

Hi I have an expression in my query that combines a number of fields for Coordinators. In most instances the coordinator contact details that get returned...

Hi , I have 20,000 records with blank names,wherever i find a record with a no name i want to fill those records with the information from my second...

I have two queries that both give me the information I am looking for. 1. Current Dept Query which has the following fields and tells me each employee's...

I am trying use the Format Function as a calculation in a query in access 2000 database. This is the field Delivery_Month: Format(,"mmm") It works fie...

MS Access 2003 on Windows XP Students can request courses each semester. Requests are entered into 5 Fields: Course1....5. Students are allowed to select...

Hello there everyone, I thought this was going to be easy, but it hasnt been. I have an update query that I didnt want to maintain, so I created a table...

I have created a report, which shows data related to insurance claims. The report includes four different groupings: Service Category (mental health vs....

Hi, I have a question about this "Command Button on a Datasheet Form". I found a summary about implementing it, but I can't do it and can't contact the...

Hey Guys, I have a query right now that allows me to pull the number of email campaigns i sent in January, and then totals the number of people each email was...

I need to simplify a post with subject "Not Null" Anyway, I added a field to a table that has a bunch of records. Obviously, the new field displays Null, how...

Hey everybody, here's my situation. I have a query that shows Field1 from a table that may contain a null value. If that value is null I would like to...