If I have a table of employees set up that has included increment amounts
along with pay steps and due dates. Is there a way to run a query on these
fields and when it finds the due date it will add 1 to the increment step
and pull out the amount associated with the new ...

Thanks in advance:
Background: Access 2003 Database with Linked Tables to multiple sources for
the purpose of reporting
I built 2 queries today utilizing pre-existing tables and linked dbo tables

I'm using a check box on a form as a parameter within a query:
[Forms]![MyForm]![MyCheckBox]
If the value is -1 (Yes, True, On) the query does not return any records yet
if the value is 0 (No, False, Off) the query returns all records with that

I can not figure out how to get a zero to show for values that do not meet
the criteria if that is possible.

As I can see in the Join Properties, it does not seem to be possible
to make a Outer Join. I can make a Left, Right and Inner join, but not
Outer Join. How can this be ?

Hi. I am getting two unwanted parameter prompts on a query.
It's a simple Select query that has two fields on which I have placed a
Count. I then have a third field calculating the difference between these two
counts/totals and it's this that seems to be casuing the paramater ...

I am trying to create a query that will pull in multiple training dates.
What I need to do is group by SSAN the training dates for an individual.  For
example, instead of having the query show all training dates for lifesaving,
then CPR, then life skills by SSAN, I would like it to ...

I've been agonizing over this all day!  This is the SQL for the query that I
built:
UPDATE [Compl P129 A3C] INNER JOIN MasterFundSch ON [Compl P129 A3C].
LOANNUMBER = MasterFundSch.[Loan Number] SET MasterFundSch.P129OldInv =

Small example of my table
product id       date    Version nbr      etc      etc     etc
2111              5/10/05        5.0          
2112              5/10/05        5.0

Hi all..
 I have a query pulling from the main table that has two yes/no check
boxes.  The query works fine when I have just one of the yes/no marked as
"Yes"..  But I would like to have it also pull the second yes/no if it is

I have a database that has several update queries that are used to update
price information. Additionally, I have a macro built that runs the update
query (that prompts the user for the PO# and price it wants to update) and
emails the changes to an e-mail address.

In my database I have a search form with all the different categories and
drop down menus to choose from.
There is a place to fill in the Date from and Date to to search in regard to
the date the document that the record referes to was created.

I have a situation were I have client from three different cities, all I want
to do is keep a track of the answer they given to five question (yes or no).
My problem is I am trying to set a query for each city and question. My
problem is what I am try to solve or end result is I ...

In the "Criteria " section I have a "Between" statement for a certain field.  
When i go to print out the report some of my fields in the database do not
infomation in them and I can not get that information to show up.  Is there
any way i can get this information to show.

I have two tables. One target and one source. Both have a primary key called
productID. The source table also has ANOTHER Primary key which makes it
foreign key. I am trying to update a few fields from my source table into my
target with an update query and I am getting Key ...