I would like to create a form that allows the user to select a number of
parameters that they could run a query (and eventually a report) on.  They
would have the option to select Budget, Actuals, Staffing, Key Performance
Indicators, etc as possible choices.

Hey, I was would like my queries to only show those that date (in the field
with the dates of my records) was in the last week.
How would this be done in the criteria?  Thanks.

I have a table that looks like this:
ClientID   RevisionNum
---------------------------------
10000     1

I have this database where i could like to caculate the 14days average price
of a stock closing prices. How can i write the expression:
Fields that i have:
[ID] - Autonumber

I am helping a client replace yet another cumbersome excel spreadsheet with
an access mdb, he is using the quotient function in excel which returns the
integer portion of a division. Not rounding.
I am having trouble finding a way to duplicate this in a query, any

Hi I am going to illustrate what i am trying to do in an example. I have the
following results from a query:
Payment#   Account #        Payment Date       Payment Amount
 1                1000                4/2/2007              $500

Sorry for the second post, but (after creating 50 or 60 unmatched queries) I
am still not able to get one right....  John Spencer has helped me with the
learning curve per previous post....
Table 1 (master table),   has 25 fields, but I have narrowed the fields

I have a DB which has contact info stored in a One-to-Many table. The main
Table has some additional contact info which I would like stored in the
One-to-Many table. Data is seperated by fields such as Name, HomePhone and
WorkPhone. These fields exist in the One-to-Many table as ...

I am having an issue with an update query and using an IF statement in the
"Update To" fields of that query.  I have 2 tables in the query ("Actuals"
and "Forecast") -- 2 one-to-one joins on Unit Number and Account Number.  
Down below in the query grid, I have Jan-Dec fields that ...

I have part numbers & their operation numbers stored as text as follows:
103-8812-10
105-1235-R
6Y-5565-50

Hello, how can I modify the code below to allow all the records to be
displayed if the check mark is off? In other words, I have a table with
records with checkmarks (Yes/No field) and records without. I am using a
query looking up a form which has a checkbox unbounded field. ...

I am working on a database with a structure similar to an order entry database.
I need help writing a SQL statement analogous to one that will generate
output that lists each order only once, and with each order only the product
from that order that is the most expensive.

Okay, I have a query that joins three tables. This query looks at several
fields and adds them, simple enough but whenever I view the query it asks for
the parameters for each of the fields where I've imput an expression. The end
result is always right but how do I stop it from ...

I have a form called frmPackage with a list box containing a query.
I have part numbers (NPN) in a table called tblPackage that look like this:
123
123BB

I could be appreciated if you could help me on this:
I have create a query to append some fields onto a new table and create a
new Index field (Autonumber & primary key). I want to calculate the 14days
average closing price of a stock price. The fields of the table are: