Hi All, I have created a cross table query and exported the results manually to the other table. Can any one please help me to write a cross table query which...

Hi all, I have a table with the following fields: PlanID PlanName LOM (plus other fields to be copied into the missing records, and a couple fields to be...

I have a form with an underlying query for data input. It is brought up by entering the primary key in a search parameter box. All works fine, except when...

Trying to find out how to Query a field that doesn't contain any characters, alpha or numeric. I'm using 'Like "*"' for find records that do contain...

Hi: I have 2 tables that have common structure. Both have 2 colums, (1) Account Title (2) Amount. I want to sum the Amount colums of the 2 tables. How will...

Hi, I have a databse with a customer table and three seperate account tables all linked by CustID. Each account table contains a field called profit. I am...

I am trying to set up a query with a calculated field (let's call it ) that contains a number of conditions. The query includes the following fields: , , ,...

Hello - Sorry for the double posting I am using Access 2002 and I need some help on my query. I have a field name "claim examiners", which I use the first...

All of my records should have a unique ID (imported from a text file so it's NOT a key). I am looking for duplicate ID#'s My select should look something...

I am developing an application which is sort an inventory system. What I need to do is load last month or weeks data minus the new product additions. This, I...

I have 3 tables "Owner", Business" and "Annual Fees". They all have a one to many relationship ie. one owner to many businesses and one business to several...

I am using the 2003 Office Professional Package In running a query in Access the following error message pops up Error(3085) - Undefined function"CStr$" in...

Hello, I have a table with the follow data: Store Quarter Month Sales Percent ID 245 2 5 3.5% ...

I'm trying to set up a cross tab query with the column headings as payroll dates (ex. 1/15/2005, 1/31/2005...etc). Is it possible to do this programmatically?...

I'm getting error about 'missing opeartor' with my query below. Appreciate it if someone can help me out here. Thanks, Alpha UPDATE VehDetail set ...

I have a query built with a "start date" and "end date" parameter. What can I enter in the "end date" to allow the query to run through "current?"

I have a query with 50 peoples names in, some names appear more than once. What I want to do it to show all names that appear more than once and not show any...

I have two tables. They both have a field "Product_ID", and are linked on this field. One table has a field Vendor, every record in this field is empty. The...

I designed a query with over 60 columns I need too enter information in each columns for the 'Description Property' is there a way to add info into...

Hello! I am looking to create an SQL statement, or anything else, that would allow me to create tables with a variable in their name. For example, I want to...