I have a query that uses the dateDiff function to calculate the number of
weeks between dates. The problem I am having is if the dates are less than a
week apart how can I get the query to update my text field to 1.
Thanks in advance.

I have an update query that updates two fields in my database.
I use a temp table so the users can enter data all day, and then come
back to it later and add to it.
Then once the user wants to update in batch, an update query is run to

I am running a query that subtracts a number in a table against a date in the
same table. Plant Date: (([Sales Date])-([Grow Weeks]*7)) The answer is
correct but when I run a critiera of Between[1st date]and[2nd date] I don't
get the filter information desired.

To whom may like to take a stab at it…
I have a query that looks at a table that I created and an ODBC table. The
table I create will have the text (this is text, not number) strings as
follows

source:
ContactID    ProjectID     RoleID
1                1                1
1                2                2

Please help me set up the following calculated field.  Need a calculated
field that equals Active if the MembershipStatus field is equal to Active and
equals Not Active otherwise.

I've used the IFF suggestions given but it returns only Not Active results.
I'm working on a case problem that reads:
Create a query to display all matching records from the tblProgram and
tblMember tables, selecting the ProgramType and MonthlyFee fields from the

I have a query that I would like to rename the columns depending on the
contents of a control on a form. For example my query [QryAll] contains
headers titled week1, week2, and week3 and the form [MainForm] has textboxes
[Start1], [Start2] and [Start3] which correspond to a date ...

I am looking for a way to order text numbers - similar to a number list order
in Word i.e. - 1,1.1, 1.2, 2, 2.1, 2.2, 3 ... etc.  These are item numbers in
a procedure list that I want to show on a form or report in 'text' order.  
The problem is that the sort order 'reads' 2.10 ...

Someone sent me this sql and asked me to try to find an answer for him. He
runs the query twice once saying where field a equals field b and once where
field a is not equal to field b. I would expect that the total records from
each run would add up to the same number as taking ...

How do I write criteria for the following?  I have to identify ids
(combination of text and numbers) that have 8 characters.  However the 8th
character can change if the id is dependent on main id.  For instance,
FRC5TTZA, FRC5TTZB, same 7 characters but different last character. ...

Hi all.
Here is my question:
I have created 2 simple tables with their relevant forms. Table names are
Customers and Friends, so are the names of the forms.

I wonder if someone can help me please.  I have an SQL query in Access 2000
that works out the number of days between 2 given dates, for example the
difference between Feb 15th & Feb 19th is 4 days.  However this includes the
Saturday & sunday.  What i'd really like to achieve is ...

I have a query that combines 2 tables, a printers table and a readings table
the printer table contains Div group location and s/n and the reading table
contains date and reading
Div    SN    Group Location    Date    Counts

I have the following query:
SELECT     dbo.qry_UV_CARS_PlateX_ShouldBeValued.Yl_iD
FROM         dbo.qry_UV_CARS_PlateX_Valued RIGHT OUTER JOIN
                     dbo.qry_UV_CARS_PlateX_ShouldBeValued ON