Hello, MS Access 2003 on XP PRO (4GB RAM). SELECT q_lvl6a_OIS.ID, q_lvl6a_OIS.OISAVAIL FROM q_lvl6a_OIS RIGHT JOIN q_lvl5_WED ON q_lvl6a_OIS.ID =...

The following SQL statement is triggering this error. Can anyone correct it? UPDATE StaffWithMonthRecs INNER JOIN Timesheet ON StaffWithMonthRecs.StaffID =...

I'm trying to run the following code which is intended to append records into a one field table. For the source of the records, I'm looping through folders...

I am using a Insert to add data to a table. If one of the fields is Null (Empty) I get this error... 3184. I can use the form and leave or Null (Empty) and...

Hi, I have a query, extracting some detail data. then. I have a second query, used to group and sum data from the previous one. If I have three Currency fields...

I have a table with two fields, Date and Sales. The data goes back 25 years. I would like a query that gives me the 365 day avg for each month in the last...

How do I set up a Query that only looks at the 3rd place of a office ID? Here are some of my office codes 1H1A, 1D1B, 1D2A, 1D2B, 2H1A, 6H3A, 4R1 Etc. How...

I need to delete accounts that the 3rd position from the left is a space.

Dear Kindly solve my problem table t1 has fields pictures, name in design view pictures field is ole object and name field is text. now in table, i have...

How to set up a restrictions as to show the month, which is 4 months less from today. I'm trying Rec: Format(,"m/yyyy") in the field and...

Hi, I want to be able to build a query with data from 4 tables (I think). I have 5 tables: tblMailing lists tblMailing list...

Imagine a fairly basic select query. It joins 7 tables together. One of those tables has two identical fields, say primary_licensor...

Hi everyone. I really thought I was getting a handle on all this till this evening. Now I am worried that my brain is going to explode. My db has two kinds of...

I have five fields that can contain either 1 or 0. Let's call them Fields A, B, C, D, E. I need to write a query that will select them if any of the Fields...

I currently have 5 tables which have been turned into 5 queries. Each query records details for work to be carried out at different Areas (ie. Central, East,...

I am working on a query that will calculate the average sell thru for the past 5 weeks rolling, by customer and SKU. My data looks like the...

I am working on a query that will calculate the average sell thru for the past 5 weeks rolling, by customer and SKU. My data looks like the...

Im turning 50 and I need to send my invitations . My theme is beach, outdoors, very casual

Is there an expression similar to Like "######" that will check for six letters?

I have looked on the knowledge base and can't quite find my answer. I need to go back 6 months from the current date - a rolling date. For example, in feb I...