I'm compiling a simple database to analyse responses to a
questionnaire, most of which are multiple choice responses. I need to
be able to have queries which show not only how many people chose each
response but also to include any response where no-one selected that

I have a table with 3 columns: wkDate, ID, Value.
These might look like this
1/5/90           10              55.34
1/5/90           20              98.42

Hi.  I am new to access and need help with the following.
I have 2 tables.  
Table 1 has 20 records in a single field with a tracking no.  
Table 2 1 has 943 records with 8 fields of which, the 7th field contains the

I have written a function that executes action parameter queries given a name
and a list of parameters.  
It splits a string into an array, passes the parameters to the (already saved)
query name, then runs the query using the Execute method, etc., then writes a

I have been given access to several SQL ODBC table containing CRM (customer
relationship managment) data.  I am wanting to use these tables to append key
information to an existing table.  I have linked the ODBC tables to the DB
containing my existing data.  I created an update ...

Is it possible to save a query to a .csv file? How?
Thanks

I hope someone can cure a small problem i'm having.
I cant put computer on 'Standby' anymore as it is unavailable to select on
the 'Turn off computer' button.
I hope it is a simple problem to cure as i'm not good with computers. I

I have a form with a CBO that has a two column table one for ID(autonumber)
and one for Department(text). When clicking on the CBO on the form, I can get
the department name appears but when it saves to the main table, the number
is saved not the name. That's fine but when I run ...

I have inhertied a database that is full of inconsistencies. I would
like to correct that. I know that I can apply a input mask but that
will be only for new records. I need to fix the existing data.
For example, with the home phone number some data is stored as

Access 2003.
I have two tables.  Master and IssuePart.
Each table has a report number (Master.OA) that ties all this
together.

I have a make table query that I would like to add an additional column and
set the value of that column to zero
This what I have thus far
SELECT BASE.* INTO NO_LONGER_IN_BULK

I have 2 tables, an empty Tbl1 (with Fld1 and Fld2) and Tbl2 (with Fld3). I
want to copy all values in Fld3 to Fld1. How can I do it

I need to convert access fields to S99999.99 format..The fiels are
currently in text format in a table and look like 1.5 or 0.40000000.
Any ideas?

I need to generate a report that lists all the differences found in the
records of two databases.  One database is a duplicate of the other, but in
another location that is physically separate.  I won't go into why...it's a
long story.  I just want to be able to list any records ...

I have a query that includes a field called PositionTitle. I want the query
to find all records except for anything in the PositionTitle field that
begins with L. What would I put in the Criteria field in order to do this?
Thanks,