I have a Make Table Query. How do I control the data type that comes from a
Make Table Query? I need the data type of the table to be a number but it
keeps coming in as text. The data type of the underlying table is text and i
can't change that. i'm using the CStr function but it ...

I am running a group by query that most of the fields are summed, but the
last field I want it to count but not every record I only want it to count
the unique entries, basicly here is the total production and how many
dealer's the production came from.

I would like to combine to table name in a Query.  I have encountered an
error trying to build this.  Could someone please assist me in getting this
right?  This is what I have tried.
(error msg:  Syntax error (missing operator) in query expression ‘[Full

I would like to write a query or macro in Access 2003 that will go through a
table and perform the following function:
If text in FieldName starts with letter "Z" then make value in FieldName2 =
"". What is the quickest way to go about this task?

I'm trying to run a query that that checks for information against a current
table. Currently I have a table set up with all of the correct choices and I
want to make my query look at that table and pull anything that is not on
that table, plus any blank information. After which ...

Good morning,
I'm having some little problems using pivotcharts in Access 2003 + latest
patches.
Goal: show a chart whose recordsource is a query that changes depending on

I have a text in a query and i need to separate
ex: Peter John Ramos that is on column i need to sepate by the spaces like
column 1             column 2             column3
Peter                   John                    Ramos

Good Day, Access Gurus,
I have a task at my job that requires creating a query that compares one
field to another field in a table and determine if, after the comparison, the
value in both fields match. If they do not match, then the output of the

Ello! Im beginner so need some help and answers plz. To make it short:
Imaginary dbase..
I have 3 tables:      Authors, Books, Cathegory (book cathegory)
Authors:

I have a form based on a query. The query is made from the following tables:
Customers
Orders
Payers

Is there anyway to have a field in a table as either a calculated or an
entered value. I'm thinking of a circumstance where if a value is present in
another the value is calculated, otherwise it is entered. Or am I missing
something really basic!!

I have a stored procedure that I use in a pass-through query and have many
such queries working fine. The select statement in the stored procedure is
complex but populates in one second when run from SQL query analyzer.
From the MS Access (2003) pass-through, I keep getting a ...

I am trying to create a report that will count the total disctint responses
for each question in a report. Here is what I have a set of 486 responses
with 40 questions. Each question has a reposinse of Yes, NO, NA or
Correction. I want to create a report to where I can summarize ...

How do you set the column width in a query result.
I have been into Format - Column Width and changed it and then saved but
when I refresh it still goes back to standard which makes the result look
horrible because nothing fits in the cells correctly.

I have a query that retreives information from one table main table. The
query qorks fin as I have a date range for the Date Recieved field and a
Like* in the Status field and it works like a charm. The proble is my manager
whats the report to pull ONLY the records where the ...