i have an employee table and a dependant table.  i need to create a
query that will list employee info and the number of dependants for
each employee, but no dependant info.  i think i need a subquery, but
not sure how to crack this one.  count function?

I am a new user of Access and have a question (I apologize if it'
already been asked):
For various reasons, I had to create one master table (Code) and relat
the rest of the tables to Code with relationships (I can't just use on

Good morning,
I am trying to determine how best to calulate the variance between two
records.  Any help would be greatly appreciated.
Price

Dear Mpv,
I have follwing data in tblPrices
ProductID   Year   Price
A123        2003   10.50

In access in one field I have one date and in another field I have another
date. I want to calculate the number of years.,months and days elapsed
between these two date. e.g. suppose in one field I have 30.06.2005 and in
other 20.04.2004 then it should show 1 year 2 months and 10 ...

I have 2 tables.
First Table (MASTERDATA) Has all the master data for a customer and
one of the fields is Total Revenue
I have a second Table (SALES) which has various records each with an

Hi, everybody,
I have such problem:
I want to generate hyperlinks for every patient, so if I have patien
number MRN and I want to generate hyperlink for every patient to folde

Access 2000
Im trying to open a parameter query form VB code I've pinched the code from
http://www.mvps.org/access/queries/qry0003.htm and modified it as follows:
       Dim db As Database 'current database

i have a table called orders and another table called techs.
in the techs table there is a field called capacity
the order table needs to have techs assigned to them each day. so if a tech
has a capacity of 5 then i want to assign him 5 orders for that day. at

I'd like to incorporate this SQL statement into my main  query as a
subquery:Here's the statement. (Select Avg(Average) fromQAVERAGE).With this
statement i'd like to create a field on my QBE grid that would calculate the
average of the below fields(i.e 200407,200408....) Is this ...

I have a database that is used to book meetings for different organisations
and in a few different places I use Combo boxes to allow choice of
organisation which then updates a second Combo box that shows the meetings
for that organisation.  I then have a third Combo Box to ...

**Also posted in Access General Questions, but upon noticing the topic here,
I felt this group might be more appropriate. Sincere apologies for
cross-posting**
Hi Everyone.

Hi, Like in Excel using a vlookup with true instead of false, the lookup will
look for the next largest value closest to that being looked for.
I need to recreate this function in Access by comparing a table with two
columns one text the other a date. I then want to look up this ...

I'm making a data base on fire hydrants of a city. I have a table with
characteristics of the hydrant and another table with the history of
interventions of employees on these hydrants.
In the intervention table, I have the fields [ hydrant id],[date

I'm a swim coach and I have a huge database of times.  I'm trying to get the
database to display the best time of each swimmer in order from fastest to
slowest.  Here are the column's in my table
Table: Swims - a table of individual swims for a swimmer over a year.  Each