Date() present today's date.
How do I present today's week (which week between 1 and 52)?
TIA,
   Tom

I have a query in which I calculate the difference between two measurements,
Left and Right.  
My formula reads Diff: [Left] - [Right]
This should be simple enough, but I am getting strange results.  For example:

i need to add a yes/no field to a linked table.
i would like to create a query that would join a table that contains
the yes/no field to the liked table.
i will use the yes/no field to allow the user to slect records for

I need some help setting up a query. Here are the details:
I have the following tables:
tblLots (this is a site in a campground)
 ID: AutoNuber (primary key)

I have 2 linked text tables. When i try to get selected fields from these
tables combined, Access asks me for parameter values for the second table's
fields.
If i hit enter and leave them blank the result i get is correct field values

Hope someone can help me on this, I have been asked to create a report that
will compare a product's sales to it's returns. Each product has it's key
"Text" ProductCode, plus the Return for that product also has it's own
product code. In the inventory list these 2 codes are not ...

I am having trouble with using wildcards within a subquery. More
specifically, I'm trying to pull information on certain model machines
from my main table, while excluding models that I have entered into a
separate table.

hi,
I have the following query:
SELECT Tbl_Resolved.ResolvedStatus, Tbl_Resolved.ResolvedDt,
Sum(Tbl_CACS_calls_between_popenterdt_and_resolveddt.[COUNT( * )]) AS

I really hope there is a way to do this.  I have multiple expense
entries for a project, all that are billable.  However each month, per
the contract we are only allowed to bill 20K, therefore I must put the
rest on hold.  Here is my question:  Is there a way to specify a given

I have a database where there is one field where each month the criteria
changes but stays constant for that whole month. For instance, during october
I'd want to always be searching for and entering data that deals with
Pumpkins (stored somewhere else in a separate table) But ...

I would like to create a filter in my query that returns all days in a month  
from 2 months ago.
Example.  it is July so I want to return all values with any date in May
only.  In August I want to return all values for the month of june only.  In

I am not very experienced in SQL, so I need some help.  Alright, typically
when I create an update query, I do a select query and get my desired results
and then convert it over to an Update query; however, this time I have run
into a few problems.  I know it is simple, I just can't ...

I have a Microsoft Access 2003 query that checks a value in a form's
combo box [cboFilterDepartments] (the combobox returns a integer ID
value) and uses that value as criteria for an integer field [alcDepID].
If the field is populated, I want the query to return the records based

I have the folowing query:
SELECT tbl_CACS_activity_by_resolvedstatusandcontactcode.ResolvedStatus,
tbl_CACS_activity_by_resolvedstatusandcontactcode.ResolvedDt,
Sum(tbl_CACS_activity_by_resolvedstatusandcontactcode.[CountOfLoan Acct #])

Let’s assume after merging few tables I have the following t1 query with 2
columns
(pk and number)
PK           numbers