I have a query that is derived from 3 tables with relationships.  i want the
user to open a form and be able to change data in that query.  i'm assuming
it is not letting me because it is derived from more than one table.  is the
only solution to this is to create a table off the ...

I have an expression that was suggested by someone here a couple of years ago
and it has worked great.  I use it to isolate the even or odd side of my
storage locations.  I have always used it in a make table query (with no
criteria) and then worked with the data in the new table ...

I'm creating a simple relational database.
I have 4 tables : suppliers list,Part List,Recipient List and Return Back
Record
Supplier list fields                    Part List fields

I have a table that has every mlb baseball team since 1871
Ex. Milwaukee were the Braves then the Brewers, in the db Milwaukee has
TeamID of  Mil, ML1, ML4
(There are several other teams that have multiple TeamID's too.)

Greetings!  Am calculating running totals for multiple fields by week.  Does
each running total require its own subquery, or can multiple running-total
fields be ganged in the same subquery?  If able to be ganged, what is the
subquery syntax including output field designators?

I have a table that contains employee ids and routes that they have closed.  
I need a way to have a query output 10% of the records per employee id.  Any
suggestions?

I have a database that includes all accidents drivers have on a date basis.
In the table I have a field for types of accidents, eg pass injury, object
thrown etc.
I wish to run a query to extract the counts of different types of accidents

In Excel, there is a nifty roundup and rounddown function...  i need to do
the same in Access... how can this be done.. i've tried the ..... +.5 stuff
and it doesn't work..
Please advise..

I have nearly finished my database and I  would like to add a query
that uses a combo box to get the results, not the usual paramater
style input. I suppose it would need a form and a query and a combo
box, but where to start !!!!!!!!

I have a table where I want to compare two results with each other from
different dates.
The fields are of my table are: MemberID, Date Of Service, Value
I've been lookining for ways to get my query to give me the following

I have the following query which I am wanting to show only unique
records in the UPC column.  I've tried using the Totals, Group By and
First with no results.
SELECT     [dbo_Item - MT].UPC_11,

I'm completely lost at this stuff. I'm trying to base a query on a form,
where I will only see details for the most recent revision to a paper. I
achieved that, but I couldn't update the status of that revision. So now I'm
back at square one.

Good morning,
I have created a query based upon several tables.  My main table has fields
that are blank until the field is filled later on, such as the following:
OrderID    < Added when record is created

I don't know if this is possible but here it goes...
I have a form based on a table that contains yes/no fields labeled "Y",
"N/I" and "N".  A comment is required when the supervisor selects that the
employee needs improvement (N/I) or is not doing something correctly (N).  

I have a very large table (‘000s records) with missing postcodes for certain
streets, I want to be able to query the table, and where it finds postcode in
either one of two fields, [From_Postcode] or [To_Postcode], then find the
match in [Street_Index_Postcode] and update the ...