I got a table called MakeModel which basically stores the make and model of a
car.
And another table called Store that stores the car that are in stock, it
also containing the Make and Model fields.

All,
I have a simple query that deletes data in a table and it is used for
updating purposes.
I am converting my .MDB's into SQL and it has been going Great until I

I built a database a couple of years ago to track students within our
program.  I have spent the last couple of months redoing the thing to make it
more user friendly.  I don't know if past criterian requests are the problem,
but I'm trying to run a report via an option button ...

I've been working on this a while, but I know nothing about Pivots in SQL and
it just isn't clicking with me.
Can anyone convert this Access query to a SQL Pivot?
TRANSFORM Avg(Tbl1!CurrWeight/Tbl1!Population) AS Weight

I want to pull out customer name & addresses based on purchase amounts for
over a certain amount (say $1000) over a certain time period. My fields are
all available in one table, but I also have many of the fields in other
tables as well. Fields include customer no, name, address ...

I have a query called qryOrders&Scripts.
The Fields are chrProgramShortName, ShipDate, Total Orders, TotalScripts,
Expression
Each entry is for one date.  I want to group the entries together by month.

I have a series of queries I must run on a monthly basis, that are make-table
type.  The tables created already "exist."  I have button control on a form,
that, when pressed, it initiated the series of about 10 queries that create
all the tables.

I'm attempting to query a field containing and ID number which contains a
date for a specific year:  Example: LN1105072
Where "LN" = Initials,  "110507" the date I'm after, and the "2" an employee
number.

H!
I would like a query to delete duplicates records only where the field "x"
is null.
Ex:

I have a query that formats dates by month and year i.e. in the table data
is 10/6/07 but formatted to Oct 07 with this code Week Ending By Month:
First(Format$([Individual Productivity Table].[Week Ending],'mmm yy')).
I need the query to sort so that Sep 07 comes before Oct 07.

I'm trying to figure out a way to populate an address table with the linking
ID of a region table. Here are the specifics:
tblLeads contains address information with a ZIP (ZIP Code) field and a
field for RegionID

I cannot find similar answer...
I am interested for correct syntax to filter query by VBA function.
Query filter: Between [Table1].[ID1]+1 And [Table1].[ID1]+4
When I use function this way:

Help,
I'm new to Access but I've worked through some tutorials.  I've got two
tables, Equipment and Repairs.  What I need to do is update the Hours field
in Equipment when I make an entry in the Hours field in repairs.  The to

I sure hope I can explain this clearly! :-)
I have two tables: Table 1 (tblJobs) and Table 2 (tblJobTickets). For each
job in tblJobs there could be one or more listings in the tblJobTickets. What
happens here is that when we get a new job it gets listed in the tblJobs.

I have a table called TReport which have a date field
called daReportDate (yyyy-mm-dd). I want to count
how many times there is a record for each month in the
table. I tried it this way -