I am trying to create a query in which data is displayed for the current
month beginning with the first day of the week, first week of the month and
ending with the last day of the week, last week of the month.
In example: Today is Friday June 1, 2007 but the first day of the week ...

I have a table with AcctNo, SecurityName, otherfields.
I need to update this table with a new field that would indicate for each
AcctNo row the number of SecurityName. for example:
ACCTNO   NEWFIELD  SECURITYNAME

I created a database with 4 tables called Items, Date, Type, and Titles.
The items Table uses combo boxes to enter the date, type, and titles from the
Date, Type, and Titles tables, since the choices are set. I can
enter records with no problems.

I need a query to that will combine data from two tables (photos,
proveniences) but the method of record selection needs to vary based upon
whether or not data is present in up to four heirarchically ordered index
fields. There is a one to many relationship between any one index ...

I have a database that has multiple dates in it. What I am trying to do is in
one field I have a date and I am want that date to convert to months in
another field. Can anyone help me on this.

I am trying to get the IDs of all those customers who have not purchased
anything in the last 3 months. What SQL query do I use?   The table has 2
columns: CustomerID and PurchaseDate.
Many thanks

is there a way of having an incremental number for each row of a query, like
an autonumber?

I am trying to use the ecount function:
CountOfAcct Number: ECount("[Acct Number]","[2a-Bad Phone Query]","[PAS Name]
='ATLANTA PAS'",True)
It seems to give me the correct total, however, I am trying to also group it

Cant understand why
CREATE TABLE [MyTable] (
[ID] AUTOINCREMENT,
[Importo] DECIMAL(18, 2),

I am trying to generate a query that will do the following:
I want the records to return from two different tables.
From the TblJC, acct field, I want the records with acct number 2 and 4, and
From the TblDispatch, contact field, I want the records with contact numbers

I'm not completely clear on the intricacies of totals queries.  I have a
bunch of fields from one table.  I want to filter them down to ANY ONE RECORD
with the LATEST EventDate of the BIGGEST FitID number for EACH Style (style
is distinct).  

I have a form where the user usually pastes a glob of text into it a memo
field called "Comment".  After he pastes the text, the cursor is obviously at
the end of the text.  I would like the user to be able to click a button and
for the comment to be highlighted from the very end ...

I need to redefine the date of entries to match a 24 hour schedule that
starts and ends at 06:00 each day instead of 00:00.
I haven't been able to find anything related in Access help files or the
internet.  So, I created a query with an IIf() statement that defines

I have two tables that are joined by item numbers. I want Table A to
have items numbers that are not in Table B. How can I create a query
that will delete all records from Table A that are in Table B?

My Goal is to show a sum of USTOPoints for each employee for the last 90
days.  If an employee has 5 points total for a 90 day period, we need to
start a
discipline process.