I have 2 combo boxes on a continuous form.
After selecting one of 4 choices in combobox1 (from a value list), the
afterupdate property is activated to assign the rowsource property of
combobox2.

I have an access database were one table stores the idnum and names of
individuals.  Then I have a table were column idnum1 references to
column location1 and column idnum2 references column location2.
I don't know which idnum1 or idnum2 would store the information to make

I will try to explain what I am trying to do, here goes.
I ave orders, bookings,locations,vehicles and drivers tables, I need to make
a query of drivers and vehicles for a specified date, then using the SQL code
in that query, create another query to search the vehicles and ...

Per my profile recently returned to college, and confidence was high till
this online Advanced (go figure that one) Microcomputers, Access 2003, class
with no book and only tutorials and the dummies book I paid $25 for. I know
this is a newbie ?, but I have struggled my butt off ...

My table look like this:
cardID    dateTime                        SwipeResult
2136    4/25/2008 9:07:19AM        0
2136    4/25/2008 9:07:46AM        1

i am trying to run a query that will give me 10% off any price
i would like to know if you can please show me what the formula for this
would look like in microsoft access 2007

Here's my question:
I have created 1 table (Clients) with 10 fields (ClientID, Name, Adress,
Phone etc...).
Next, there is a form (Clients) that allows me to fill data into the

Each customer is required to make a 10 percent deposit for each job. I need a
query to display Job ID, Customer ID, and deposit amount fields for every
record in my Jobs table. The fields that are included in my table are:Job ID
(primary key), Customer ID, Job Description, Job ...

I want to set up a query that has
Product Name
Yes / No #1
Yes / No #2

I have this "iif" statement in a Query that is giving me problems, quite
frankly I'm just having problems writing it.  Any help is appreciated.
Thanks
DS

I have created a crosstab with ProjNo (text) as the rows, ExpObj (text) as
the columns, and the sum of Amount. I can use the property sheet to format
the overall total for each ProjNo as Standard 2, but the total for each
ExpObj within ProjNo is in general format no matter what I ...

The VBA documentation says that UNION queries can use SQL statements as data sources.
The documentaion on JOIN queries implies that tables must be used as data sources in JOIN queries.
If this is correct, what is the most efficient way to create a table in VBA and move a recordset ...

What I'm trying to make is a Union Query that has a field for table names and
lets those table names be a parameter.  I have figured out how to do
parameters (where option), and I have figured out how to do a field for table
names ("table name"), but combining the two is beyond ...

ok this is probably so simple. i made a query in including last name, first
name, projected salary and bonus for a business. i need to calculate the
total salary ( projected salary + bonus) and i dont know how.could someone
help?

I would like to make a query that shows a 10% deposit for each job in my jobs
table. I would also like to include the Job ID, Customer ID and deposit
amount field for every record in my table. Can someone please help me, it's
probably something really easy, but I have been ...