I have 2 tables. Department (one) linked to Phone Book (many). I want to
delete record in Department table where there is no record in Phone Book
table.
DELETE Department.*, [Phone Book].Department

I'm looking at moving Access 2002 to 2007. There's a database query to
extract accounting records and grouping/totalling by year. 2007 rejects the
format as 'Undefined function format$. It's -
Field: Date By Year: [Format$]([Accounts - account transactions].Date,"yyyy")

I need to run a transfertext command based on data specified on a form. Part
of this is a multi-select liist box. So I need an WHERE... IN(... ... ...) in
my SQL based on the listbox selections. Transfertext requires a query so how
do I create a query in VBA. I have all the code ...

This is odd:
I have an ODBC connection to an Oracle db.  In this one table I see that almost
every single record is duplicated resulting in nearly half a million rows.  I
thought I'd run a SELECT DISTINCT query against it so I could work with a

I have a table with a date/time field. I need to get the top 10 distinct
dates (ignoring time portion). I tried:
SELECT DISTINCT TOP 10 Format(RecordDate,'MM/DD/YYYY') AS RecDate
FROM tblAddress

I have a table that tracks steps completed in a project. The steps are setup
as yes/no boxes. I am trying to write a querry the will bring back the
current step in progress.
For example, there are boxes for pursuit, purchase, construction, close, etc.

How do you change columns into rows in MS Access?
EX:
FName  LName  
------------------

I have a table containing several Projects, Areas (where project takes place)
and projects Phases.
I made a query that Counts the total of projects in each area AND phase:
Query_Projects:

I am getting a #Error message in the AMOD field of my query QUERY1:
AMOD: iif(IsNull([MSIZE]),"N/A",DLookUp("MOD","QUERY2","MODID= " & [MSIZE]))
MSIZE is a lngInt field located in 'Query1'. Sometimes it has a Null value.
MOD is the value I want to retrieve from QUERY2.

I have a table of approx. 128K records.  These records contain an account#,
date of service, & charges.  I have written a query for this table to provide
a count of all accounts after a specific date and sum the charges; by month
and year.  The query will successfully run, yet ...

I'm trying to code a subquery on a table but to no avail...it's a very simple
table that has Date (short date, just recording the day) and NAV which is a
number (double).
All I'm wanting to do is have a query that displays the Date, the NAV and the

I have created a table where the value is Yes/No - text with default as No.  
I have a query in which I am trying to bring back only the "Yes", but both
yes and no are being shown.  
Any ideas? Thanks

I want to secure my Access MDE file so that My users can not go to Design /
SQL view of the query. Currently after opening query through command button
provided by me on form , any user can press right click button & Go to
design/Sql view of the query & fiddle with it. I want to ...

I have a query which i would like have a parameter use when a user runs the
query it would promt for a date between recvd date and invdate. Though some
records do have null values in the date field, i want to be sure that the
quey picks up all records. How is this set up?

I have a table with 5 fields
ID  PersonID EDate Amount and TransType
I want a query with the last record of each person based on date and
I