I have a form that captures a lot of information on actions involving
different products. This information is organized in a datasheet subform
where each line is an action involving one product.
I would like to have a way to capture the same information  in a more

I can create a pivot table to show data from a query in the view that the
user would like to enter the data into.  However, the pivot table will not
let me enter or change the data...the underlying query will let you enter or
change the data (and if I change to datasheet view I ...

I have a query that goes like this:
SELECT Avg([Boiler steam production]![CurrentSteamFlow]) AS [Average_lbs/hour]
FROM [Boiler steam production];
I assume that this is going to add all the fields in the CurrentSteamflow

I' m trying to build a report based on a select query.
One of the querys fields states a price for a date series.
I would like to retreive to my report the higher value for the price column.
I tryed a textbox in my report that says:

With respect to my earlier post, I am trying to find the best way to
dynamically alter the select list of a query.
Any suggestions!!
Cheers

I have a database with student names, student id numbers, parent names, a
family number and email addresses.
Every student in the school is listed multiple times because they have the
multiple parents.

How do I use criteria to show or not show a fiel, for example, I have an IIf
function:
IIf([Forms]![FormName]![ComboBox]="Text",([Query].[Fieldname])=True)
I would only like to show this field when the criteria is met and block out

I am using Office 2003 on Windows XP.
Please note that the use of spreadsheets is per boss and user preference -
this is mandatory and beyond my control.
I have a table in which there is an auto-incrementing column that will be

I have a database that is just huge, and at some point in time the company
will have to archive the data in the tables, for the most part I can do this,
the problem is with my linked tables. I don’t know how to archive them all at
once.

I have numbers like those below in a column of data I am using in a query.  I
need a formula to change it.
1013-14
123-1

I need to create an expression to total 2 columns.  The 2 columns are
Qunatity 2 and Quantity 3, I would like the 3rd coulmn to be Total
Shipped:...  Can you please lett me what I need to type in the expression
field.

I'm trying to create a query, but i've problem because i'm not an expert!
I have these two tables:
TBL_OF:
NAME|SURNAME|SEX|ID_CODE|BIRTH_DATE|STATE|CHOOSE|IDREG

I am looking for some assistance with getting some information from a form
into a query that goes directly to JET. Presently I am having the error “too
few parameters”, when I try to input the values using the
Forms!FormName!FieldName format. Is there any way I could do this?

I have two tables that contains almost the same information. The only
difference is that one of the tables (Dagsrapporter) has about 400 more
records than the other. I want to pick out only the records that are not
present in the other table (Dagsrapporter_20050702).

I need to check a large amount of sequential data for duplicate items,
missing items,
start and end of sequences, and other anomalies. The approach I am using is
to create a query that is sorted in asecnding order, ther using a make table