I've got a form with some comboboxes, five checkboxs and a command button on
it. The command button simply launches a query.
I'm getting some very strange behaviour:
When I check the first checkbox the query runs fine. However, checking any of

As suggested here I made two switch queries but, after many attempts I have
not been able to work out a way to select correct query to use. If 8 years
service by 1-30-2005 then 80 hours vacation.  If not use NewWTime and they
would only get 40 hours at 8 years. I have read all I ...

I have the "many side" of a one-to-many relationship (i.e. multiple rows) and
I want to flatten this to make these rows into columns.  I am trying the
pivot query with the transform statement, but I don't believe it is going to
work.  Can I write a non-numeric cross-tab query to ...

i have a huge table  and have several records that are duplicates, is there a
way to get rid of one of the records where the loan # is a duplicate?   for
example
name           loan amt       loan#            

I have a report that the user would like to  type in only the month and Year
in the following format: Jan 05. Then the report would show the report with
only dates for Jan 05. Only one month per report.
I know how to do a like query for just one date

I have a large list of names in a database table which includes things like
account # and Date of Birth, Address, etc.
I want to run a query looking for possible duplicates.  I don't have the
duplicate query 'query selection', the only two Query choice are from Design

Hello,
I really hope someone can help me...I am a novice at this....and here is my
problem.
I am attempting to create a database which tracks the spending of a program

I am trying to do an update of a column with data from another table.  The
following T-SQL
UPDATE titles
  SET ytd_sales = titles.ytd_sales + sales.qty

I hope someone can hep me. First here is the query (Thanks John and Bill)
PARAMETERS [Begin Date] DateTime, [End Date] DateTime;
SELECT FSAClients.EthnicGroup, Count(*) AS Total, Count(*)/(SELECT
Count("*") FROM FSAClients

I have the following calculated field in my query:
Total Paper: nz([legal 8 1/2 x 14 cost])+nz([ledger 11 x 17 cost])+nz([color
copies total])+nz([colored slip sheets cost])+nz([total paper cost])+nz([misc
paper total])+nz([thermal cost])+nz([spiral cost])+nz([booklets cost])

Using Access 2000, I am trying to make query for production  based upon two
variables; "Location" and "Employees." Each location and each employee is
assigned to a specific market, and the location and individual could be in
the same market.  I created an inner join, trying all ...

Hi All: Using Access xp dev. Is it possible to write an append query that
appends records from one database to a different database?
Thanks, Ed