Hi.  I am newish to Access and have a question.  My friends familiar
with Access don't know the answer to this one either.  I feel like it
is just on the tip of my brain but I can't get it.
How can I select an item in a table based on the date?  For example,

<Repeating my post to the Access Multiuser group in the hopes of
eliciting a few more responses to this issue>
All,
I recently split my first database application into a front end/back

I have a table with 4 fields and some duplicate values in Field1. Field2 has
values, but no duplicates.  Field3 and Field4 are null at this time.
I want to Group values in Field1, and update Field3 and Field4 with values
in Field2 for the duplicates in Field1.  Rather than have ...

I have some custom append queries wrapped inside a transaction. They execute
just fine using the db.Execute, strSQL, dbFailOnError method.
Problem is, after the ws.commit instruction, the records are not in the
tables where they are supposed to be!?! Sucessive attempts at this ...

I need to make a crosstab query that has, as a column heading, the date of
the beginning of the week in which the date value in the record falls. I know
how to make the heading be a number representing the week of the year by
using: Format(ShipDate, "ww"), but how do I convert ...

I would like to set-up a query that will extract the date for January based
on the Date field being between 1/1/2008 and 1/31/2008. This should be a
continuous process through December. The year is associated with two amounts
that I want to be the total of the 2 fields added ...

I have text data in my table formated 11-11-11.  I want to change the "-" to
":" so the result will be 11:11:11.

I try to converet this simple If...Then to a Case...When but get error
mesaages.
Anyone can help me to pinpoit my error?
IF...THEN  (which works)

All right.  So i have several fields in this query.  Here's my problem: if i
remove the part about "alba" "natasha" and "yohannes" it includes everything.
whether the field is null or not.  If i have that field and restriction in
there, however, it also removes any of the ...

When I run this query I get one nember for cases shipped.
SELECT tblInvoiceHistALL.[Ship Date], tblInvoiceHistALL.[Cases Shipped]
FROM tblInvoiceHistALL
WHERE (((tblInvoiceHistALL.[Ship Date]) Between #1/1/2007# And #12/31/2007#)

woI am comparing amounts in tow fields:Billing Difference:
IIf([SumOfAmt]>[AmountEst],[AmountEst]-[SumOfAmt]), which gave a lots of
empty fields and one field shows 0.00.
My second step is to show only the fields which: is not null or <>0.

I hae searched the forum tono avail, so I'll ask for help.
I have a table [Scope Event Table] which records events with status changes.
The table uses an auto numbered primary key (not shown in the example
below).  It has data like this:

if field1 is greater than zero and less than 1 than 1 otherwise 0
Whats the right way to write that expression?

Hello,
MS ACCESS 2003 XPPro
So I have this form with some fields that the user fills in by hand.  They
don't link back to a table or anything but some VBA calls an append query

I'm not even sure how to title this question...
Table_1 holds values for DATE, PLACE, TYPE_ID, SIZE_ID,
SHAPE_ID, and QUANTITY.
Table_2 (lookup) holds details for SIZE.