I am using a combo box to look up department names.  When I select the
Department name, I need to also get the Department number in the same table.
I do not know how to get the number at the time I am picking the name.
The way I have partially solved this is to pass the Name to a ...

Here is part of my database:
tblStudents: StudentID
tblMajorsAndStudents: StudentID, MajorID
tblMajors: MajorID

Here' s what the data looks like on one record from the table I'm trying to
query to compute payroll. Each record has over 30 fields, but I'm only
concerned with a basic strategy for now. Each word represents a field on a
record.

DCount("field1","QueryName","field1 <='" & [field1] & "'") works fine with a
text field. What am I missing for an autonumber field? I get data type
mismatch error. TIA
-JS

Win XP - Access 2003
I have a report that shows 4 yes/no checkbox fields.  
The report is based on a query called boardsQry.  
I only want the report to display records if any one of the 4 checkboxes are

I've been trying to join a text field & numberic field in a query, but every
thing I try I lose the decimal places.  Can anyone help?

I have a (simple) query trying to learn how to mix inner and outer
joins in access, I'm getting a 'Join expression not supported' error.
SELECT CUSTOMER.CUST_ID, CUSTOMER.CUST_NAME, TRANSACTION.PROD_ID,
PRODCUT.DESCR

I'm looking for a method to query for the actual rent paid for given month.
Example:
The RentRate would be the monthly rental charge for a full month only. The
first month a tenant pays only for the days rented (prorated) so unless he

I have 5 tables;
Customers
  CustNo
tblSales2002

I have a select query called qryRandom that grabs a random number of
clientID.  In that query, i set the top value to 100.
In another query called qryViewTrips, I linked the qryRandom with tblTrips
(via clientID).  This query will grab all the trips of the top 100 random

I am trying to create a backup copy of a current spreadsheet, and I want to
call it a backup copy and place the month in the title of the file.
Can anyone help me achieve this.
PR

I need the count the number of entries in each grouping:
This is my data:
CHPSN    CHDOCO    EXTCOST
17540678    60117419    40.44

This is probably a really simple query but the solution is escaping me.
In an adp, I need to know how many times each production line (listed in
Line table) appears in a separate Run table for each date.  I have that
working as long as the line occurs at least once (using INNER ...

When I am in the Query view in Access, it will not allow me to 'center' align
data even though the icon is visible...how do I change the alignment?

I receive a table with a field containing lastnames with a first name initial
(For instance: "BakerK") I want to strip off the first name initial and show
only the last name in a query. I know I can use =Right([lastname],1) to
return the last character on the right, but how do I ...