I'm stuck with a query I can't seem to be able to write, would be very
grateful for help. This is Access 2000.
I have 5 tables
- table 'persons' with identifier personID (+ some fields)

I'm looking for a median function in Access for using it in querie
with "group by".
I did find a few examples of good VB-code, where I even can suppl
optional criteria. This way it is possible to use it on "grou

I have a table containing those fields:
   VehiculeNo
   Date
   Odometer

I have the ODBC Connect str of access 2000 pass thry query ,pointing to
oracle driver.How can I  set the ODBC Connection string of Pass thru query
dynamically from the VBA code. I want the string to point to production
environment or development environment based on the choice ...

I need to build a query that returns a daily change from a table.
I need something like this:
Date     Value@date    Value@date-1      (Value@date / Value@date-1) - 1
Or else, just the first and last field.

Can I ask Access to filter out say, 100, randomly chosen records from a large
list? ie no criteria but just specify the number of random records I want?
Thanks
Sally T

I have mutiple queries set up to manipulate a single table different
ways.When I update my table it is not reflected when I run my query,why?

I have a form to make the invoice. It has one cbo (Information abou
Clients) and inside this form I have a subform whit a cbo (Products)
One client can to buy several products by an agreement.
I made a query to view the clients related with the products and

this is a simle query comes from a table1,
SELECT Table1.number, ([Table1!number]) AS code, Table1.name, Table1.surname
FROM Table1;
i cant understand why im changing the code field to-->Left([Table1!number], 2)

I've got a query which looks at rolling year to retrieve data and I'm not
able to set it to run via a macro because of the date criteria.  Every week I
have to go into the design of the query and change the dates to include last
week.  Is there a way around this?

I have the following formula in a query in order to retrieve records that
fall between two dates:
Between [Start Date] And [End Date]
However, when I run the query it doesn't include records for the end date

Here’s what I have and did with two tables.  
Have tableA (91K records) that has duplicate records.  Created a blank
tableb from tableA structure and made primary keys on selected fields.
Appended tableA to tableB.  TableB now has unique entries, about 41K records.

how to make a query using SQL to get customer info by just entering the
telephone number?

i have a quantity feild in a table of stock entry, i also have another
quantity feild in a table of item sales.i want to the quantity sold to always
be subracted from the quantity in stock and the result to be the basis for
the the next calculation such that the quatity feild in ...

I have two drop down boxes for the user to search for a product
one is by Reorder#  and the other by NameOfItem.
I am thinking about using an underlying query To prompt the user for a
word .             Like ([Type a Word]) & ("*")