I'm trying to create a query that can total week-to-date, month-to-date, and
year-to-date stats.  I think a separate query for each would be easist?  
Also, prompting for each query would be preferred.
An example of each record would be:

I have a database table with among other column names: DateRecd, DatePaid,
DateClosed. How do I write an expression to show only record with no date in
the "DatePaid" column

Good day,
I am having a problem with a subquery and was wondering if there is a better
way to get the result needed. I have a table with customers and need to
exclude some of them based on a listing in a query that I created. The query

Access 2003
I'm trying to build a query where the two tables I am using have a common
field and I need a calculated field. I need to identify in the calculation
which table the field is referencing and I can't remember how.  

I have two tables; Collectors and Reassignments. I have a form that has a
tick box relating to a field in the Reassignments table. It works perfectly
fine untill i try including a relationship between the two tables and then it
won't let me change anything. How can i get around ...

I created a report which has Suppliers as row headings, PayDates as column
headings and dollar amounts coresponding to suppliers/dates (cross-tab). In
the report footer I have another report which shows Totals for the respective
PayDates (1 row crosstab).

I have a list of numbers most of which are duplicates.  However, some
numbers are listed only once.  I would like to create a list of the
numbers that are only listed once.  Eliminating duplicates is not a
problem, but how can I isolate the numbers listed only once.

I have an orders database and want to search for all orders in a given month.
I would like to be able to enter (ie in a paramter query) and then filter
all orders by that month.  Could also be applied to a given year.  The Date
field is in Medium Date format.

I have the following Table and want to make a query:
Table1 has the following records:
ID
Shot1

Is there a way to average a group of numbers in a query and not include the
0.  I know I could say Not 0 in the critieria, but I need the other fields to
show up regardless of this one particular record as a zero

I want to create a new field in a table that combines the calendar date and
military time from two other fields.  Is this possible?  I have tried to
combine the fields in several ways but my knowldege base for such expressions
is limited.

I have concatenated two fields, both of the Text Data type.  When I do an
unmatched query to check this concatenated field in two recordsets, the
expected results come up for a few seconds, at which point I get the infamous
"Data Type Mismatch in Criteria Expression" error, and ...

I have a table with a field containing song lyrics (Table=master,
field=lyrics).  I need to provide a user interface so that my users can
search the lyrics field.
The problem is the users need to specify what type of search they're doing.  

Any help would be greatly appreciated.
I have a large output report from a database.  I am trying to narrow down
the information in it.  The goal is to take a list of users and isolate the
rows that apply to those users.  I have one table, 'Users', with their names

Hi Folks - Currently, I am using the Error Event of my form to capture
duplicate key entry. However, this is not invoked until the form updates. Is
there a way to check for a duplicate after the user tabs out of the primary
key field? Thanks.