I have a tblProject that contains projects and their phase of execution.
Each project can be in one of the following three phases:
Portfolio, Pre-project or Execution
I want to show a table in a form containing the names of projects in each

I have a crosstab query with the SQL below for flow measurements. I am trying
to place the sum of cell averages on a form. I've entered the expression
=DSum("[CellAverage]","[qry_VolMeterCrosstab]") but get an incorrect result.
Any suggestions? Thanks,

I have a table which has several number fields using mainly 1, 2 and 3.  I
want to make a query whereby I can show there was for example 4 1's, 6 2's
and so on, in each field.  Is this possible, if so could someone please tell
me how to make up the query.  If not could someone ...

I have 4 different queries that i want to be exported to excel i know how to
do that with the macro
But
Each query has a between criteria. As it is right now when I run the Macro I

I have a table with 41,000 individuals (their first and last names) and a
separate table with 45,000 individuals (with first and last names and dates
of birth).  Most of the individuals in the tables overlap.  
I'm somewhat new to Access and am trying to match up the tables so I ...

I am building a warehouse management database from the ground up. The problem
I am running into involves the 'location'.
Problem #1- I have an "Upcoming Shipments" table which is just data pasted
from an external spreadsheet e-mailed from clients. I then have a query that

i accidently erased or deleated a blog i wrote on myspace today 7-24-07 i,m
using windows98 but i need help finding my new blog

I have a datbase with 5,000,000 records. I need to work with records
1,000,000 to 2,000,000.
I see that Access assigned unique ID's to each record. Can I use this to
filter for the data I need ?

Does anyone know if there is a way of logging changes in a database?
I am trying to keep track of lead time changes in a database. For a
vendorID, everytime its leadtime changes, i want to be able to log the date
the change was made and what the value of the lead time was before ...

Is this possible? I have dates (some of which are the same) and I
would like to use them to create a running sum of another column in my
query. Is this possible?

I am using this function in an update query to try and strip out invalid
characters in a memo field.  The problem is when I export this memo field to
Excel, it corrupts excel.  I'm pretty sure the problem is with invalid
characters in the memo field.

I have four different types of salesmen, SVP VP SC and EA. For each
sale that is recorded, any combination of these types of salesmen can
be entered in. However, they are not all always part of a sale so
sometimes there are mutiple blank columns in a sale.

I am running a query to return a count based on a specific condition. The
name of the query that the information is being pulled from is "raw
extraction" (raw extraction is a query which I use to pull numeric values
from text fields in the initial table). I have changed the alias ...

   I have a maintenance work order database. I want to do a query for a
graph. I want to show the total work orders issued in the past months. I have
done this using the query by example screen and plotted in a chart.
   Now I want to add to the query and chart.  Each work order ...

I have a report run by MainQuery. When I click on the main query it is
queried my LeaseName. I type in Cromer #10 and everything comes up. I type
Franks 19 #1 and it comes up fine. When I go to the Report and click on it,
Cromer #10 comes up in the report but when I type Franks 19 ...