I have the following simple table:
Name            Appointment           Salary
********************************
Adrian           Manager                $2000

I am trying to create an append query (or whatever would work) that
will allow the creation of repeated records in a table.
For example, I have a table with these fields (1st row) and example
data (2nd & 3rd rows):

I'm having problem with the Make Table Query below.  I have a table
with month, day and year stored as three separate, 2-character string
fields (I did NOT design this database).  I need to write queries that
compare dates so I came up with this query convert these string fields

I need to write a query that will return ALL records from a field that
contain a specific keyword, which in my case is the word SEC.  My table name
is Legal.  The field name in question is legal_description.

Hi again,
I want to add a number field to a existing table and insert the number 6015
in the first row and then increment
that number by one for each row after that?

I'm very familiar with working with Access and creating and sorting queries,
but today am having a problem I've never encountered and I need help fast.
When working with a query I created several days ago and have been using
regularly, suddenly after I added information to quite ...

I have a table in which each field contains duplicate values. I need to
summarize the data based on the values in one of the fields, like this:
Fields: item, brand, size, type, formula
summay:

Currently I have a query that will do a sort when you type in the Job Name.  
But if you don't type in the name 100% correct it will not sort correctly.  
Is there a way so that when the box appears on the screen that a person could
go through a scroll down of possible name choices ...

Hello, there.
Based on the date and time information, how to return the value of
"firstdayofweek" in Access? I don't see any built-in function which would do
that. Thanks!

I am creating a simple query.  The table is InsuranceExpense.  The field is
InsAmt.  There is nothing in the table yet.  I put TtlInsurance:
Sum(CCur(Nz([InsAmt],0))) in the row marked field.  I get only a blank field.
My goal is to use the zero in a calculation with another ...

This works for SQL 2000 how would I write it for
Access 2003 query?
STUFF(CONVERT(CHAR(26),GETDATE(),22),7,2,CAST(YEAR(GETDATE()) AS CHAR(4)))
thanks

I have created a donor database in Microsoft Access for the non-profit
organization i work for to maintain information on individuals and businesses
who donate and/or participate in our fundraising events.  So i have a main
table of donor records, then tables for each of the ...

I need help on writing a JOIN statement in ACCESS.
I have attached a portion of a query used in Teradata SQL Assistant 6.2.
cast(substr(cast(a11.mdse_nbr as char(4)),2, 3) as int) = a12.sub
This portion of the SQl represents the join expression needed in ACCESS.  My

Greetings everybody,
I'm quite new to Access and SQL - until now worked a lot on Excel and some
VBA macros...
I would like to write a query that will extract me all the records where one

My appliction was connected to SQL SERVER, and was using a STORED
PROCEDURE (created using T-SQL) in SQL SERVER.
The code for the procedure is:
CREATE PROCEDURE proc_name