I have two tables where a particular field can have one to many
attributes. I am wanting to exclude a field in table A if it contains a
particular attribute in Table B. For example, a customer can have 3
types of credit cards ie (Amex, Visa, MC, Discover).  If a customer

I have a select query where records are grouped according to Car
Manufacturer. I want the query to also Average the 'Mileage' field, but
only for records where the Mileage is Between 45,000 and 75,000.
At present I have an 'Avg' in the Total field and 'Between 45000 And

I have a table with filed1, field2, field3, Field4, field5, etc.  These are
numeric fields, except field1, which is text.  I'd like to create a second
table with a TotalField which contains the aggregate of each field2 to field4
and it's grouped by field1.

Hopeing someone can help me here..
I have a main form with 1 subform, I want to make a query that returns data
for the main form, but using criteria from the related subform.
The problem i'm having is, if i use a normal select query based on both

I want to write a simple query using the pubs database.
I want to show title, au_fname, au_lname
there is no link between titles and authors though.  there is a titleauthor
table that links the 3 tables together, but i do not know how to write this

I am new to Access and I can't for the life of me figure out how to to this
I have a column of account numbers such as
723031
723032

I'm trying to get this result using one select query. The ProdTtl field is
the sum of ProdAmt within each Function.
Function          Prod         ProdAmt            ProdTtl
1010                100           7,782.36           279,559.20

I have a SQL query that works fine on an SQL server database but not on an
equivalent Access database. Can anyone please help me tune the query to
function in Access?
The query looks like this:

I am having a problem with DELETING files from the tables. I have the code:
Private Sub frm_cmd_Delete_Click()
On Error GoTo Err_frm_cmd_Delete_Click
   DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70

I am trying to clean up a previously built database and normalize it.
I made a table with employee names and a primary key autonumbered
Violator_ID.
Now I wanted to run an update query to add the Violator_ID to the

I'm running an append query to append data from one table to another.
These two tables have the exact same structure, data types, etc.  However,
when I run the append query, about 5% of the records to be appended are not
appended.  Access gives me a message that these records ...

I am new to SQL server...
I am getting the following error on this sql code:
Server: Msg 156, Level 15, State 1, Line 5
Incorrect syntax near the keyword 'Like'.

I need to round to the nearest 1000. The Round function in Excel will do
this nicely (Round(Value, -3)). However, the Round function in Access
will deal only with the fractional portion of a number, and
correspondingly will accept only positive numbers as an argument.

hi,
I have the following:
TRANSFORM Count(Tbl_masterpop.[Loan Acct #]) AS [CountOfLoan Acct #]SELECT
Tbl_masterpop.status FROM Tbl_masterpop WHERE (([popenterdt] between

I have a straightforward table that is populated each day. I would like to
write a simple SQL query that calculates the daily change for one of the
variables.
The table has 3 fields/columns Date, Name & Price.