A field contains the 4 digit year. In my query I put >2003 in critieria to
show this year & last last year data only. I would rather be flexible & code

searched this forum & looked in some books  but ...

Wonder if you could help with the following, i need to display in a query the
ages of people but the age range categories are already defined.
For example, a person would be aged 8 and would fall in the following age
ranges 01/09/1996 to 31/08/1997 he or she would have the date of ...

I have a table that contains appraise_date and next_appraise_date fields and
what I
need is when the user enters the next_appraise_date, it gets updated to the
next record as appraise_date.  so i get the following occuring.

I have received great help here, have searched, but cannot locate answer to
question.
I have a table with 170 records, each record has 10 yes/no fields in it.
I need to count the number of times "yes" occurs in the entire table, and

Helloooooo :-)
IN BRIEF:  I built a query which returns the correct set of records. Then i
added a MIN and COUNT function but had to turn on the query builders "TOTAL"
row to get the functions to work. Which im not sure was the correct way of

I am summarizing data like this
SELECT dbo_Order_Line_Invoice.Cono, dbo_Order_Line_Invoice.CustId,
Year([Invoicedate]) & '/' & Format(Month([Invoicedate]),'00') AS
[Year-Month], dbo_Order_Line_Invoice.VendId,

I write to write a Query that can return all rows or a specific row by
passing a parameter.
parameter custparm integer;
select * from customers

I have a SIMPLE Database with the follwing fields:  TITLE ARTIST MEDIA DATE
SOURCE
When I put in a value for, say, Title or Media (45, CD, Tape, etc.) or date,
it works and I get a table for every one of the asked for listings; however,

 I have a query that looks up data in 'tblInventory'  and returns
information that is between a date range.  IE 'Between #7/1/05# AND
#7/31/05#.  The problem is that there is not always data for each date in the
range.  I am looking for a way to have the query return ALL dates ...

Access 2000.  I have an employee db. where employee timesheets are entered.
I need a query that will return missing dates or if a timesheet from a
particular date that is missing.  I have a field for entering the date
[Currrent_date]  and a field where I enter [CID] "First Day" ...

A co-worker of mine wrote a pretty straight forward query with criteria. The
results that are returned do not match the criteria that is input.  Records
with RR.PAYEE_ID="N0115444" are being returned. How can this be?
SELECT RR.TRANSACTION_ID, RR.PAYEE_ID, RR.ORG_NODE_ID, RR ...

I have a dataset of daily precip values over a 30 year time span (a table
with 11,000 plus records) . So basically for everyday (date) of the year I
have 30 precip values. I am trying to create a table that contains the
average precip for every date, i.e. Jan 1, Jan 2, etc., over ...

Is it possible to have a query that joins two tables where table1 may not
have a matching record to table2, and in this event you could CREATE the
matching record in table1 by adding data to a field?
For example:

I am working on a survey that has 50 questions. Each question is a rating
system from 1 to 5.  I am using the Lookup Wizard data type for each of the
survey question. I have separate columns (fields) for each question number,
similar to a spreadsheet. I have a column field for each ...

I'm a novice Access user, in 2003.  I have a table that is linked to 2 other
separate tables with 1 to many relationships (3 tables total).  When I run a
query with all three tables, I'm getting the cartesian product of all the
tables.  How do I eliminate all the duplicates?