Hi All: I want to update a query with a set of new data. Every thing, such as query format and reports for this query, is the same. Could anyone tell me the...

I posted yesterday the message below about a function to find out the current workweek for a deadline list. The answer below helps me find out the weekday,...

Ok, I'm very close to having this done but I'm in a glitch. Here is my SQL that I got to work. Thanks John for the help on this, I had to drop the WHERE...

I have information listed in a MS Access Database (Office NT) in fields FirstName and LastName there are many duplicates. And of course there are...

Good Afternoon, I created a deadline list (an access report)for our department based on a query. The information, based on the week it is due, is sorted by...

Hello, I want the query to select records of a specific five digit number such as 64252.Would the "like" criteria select this number and only this...

Hello, How can I, using one parameter (for example weeknumber) letting this parameter be the base for two or three queries? Now I must enter the...

Hi all, Say I have two columns as follows Individual age A 3 A 9 A 12 B 2 B 7 C 23

Hello, I want to put pictures in my forms. I've borrowed all the code from the sample Northwind database. It errors on the code: With...

I have been developing access databases for over 5 years. I have a large database and I have struck this problem with it before but can find nothing in help or...

How do I querry a table that has a 5 digit number as the key to determine if there are any numbers missing? For example: My table "orders" currently has 1118...

I GET THIS WHEN I WANT TO COPY, WHAT DOES IT MEAN...REALLY? MOST OF THE TIME IT GOES GREAT...THEN I FIND A REALLY GREAT PIC AND THIS MESSAGE COMES UP.

I am trying to pull out all records where the field (text value) does not have "cell" in it. The feild has phrases in it, ie. "cell phone" or "dell server"...

I have a tblpayroll table with the following fields: tblpayroll Period Dept. Hours Code Hours I also have 2 other tables

Hopefully this will be an easy question. I have a main table and three other tables that hold descriptions for some of the columns in the main table. I put...

Hi, I have a query that holds 3 addresses. Each part of the address is seperated by a comma. I want to be able to compare each address to find differences...

I'm using the DateDiff function in a query and it works fine until I try to set a filter to only show the records where the difference 0. When I add 0 to...

We have an employee database. I would like to run a query that tells me who was working for us at a point in time. Example: what drivers were working for us...

Could any one tell me how to combine two variables in query? Is syntax Concatenate (text1, text2)? But where can I tpye in these syntax and except these...

Hi, I struggling how to specific criteria in the query from a table that grouped by month of shipdate. I would like query to count only if ship month is equal...