I'm working on a database to help track information for our agency's
cafeteria plan.  For employees who were here before the start of the year, I
can use a query that divides their total desired yearly witholding by 26
(number of pays per year) in order to calculate their ...

I have a form for a rolling report. I need to add some criteria, and I was
doing so in the query end of it, that has the following:
ClassID = 12 or 14
This is all based on what Class they select from the form. Class ID 14 or

Error in Access 2007:
Changes to criteria in a query used as master query are not reflected in
sub-queries (which refer directly, and only, to that master query) unless the
database is closed then re-opened.  Why?

I am not sure if there is a way to do this, but any suggestions would be
greatly appreciated!  I know how to view the modified date for an individual
query, however, I would like to be able to view the modified date(s) for all
queries at the same time.  can this be done?

hello to all
I would like to restate a question I posted a few days ago in different
terms.  I received excellent advice from Allen Browne and John Vinson but, as
a beginner, I'm having trouble implementing their suggestions.

I have a table with a list of people. Also included is the date that
they gained a certain qualification. This qualification needs to be
renewed every two years.
I need two pieces of information from this table.

Experts,
I created a function to run multiple update queries in my
application...  it worked fine with 2 update queries, however it
stopped responding when I try running it with 4 update queries.  Is

I am hoping someone can help me.  What i am trying to do overall is to get
data out of my sql db.  Build a quiery within Access and output the data as a
ms datasheet with a chart.  Sorry for the long question.  I am not great with
sql and access.

ozip   dzip    shipdate       wgt         Transport cost
A       B          12/1/07    20              450
C       D          4/1/08      15              890
E       F          9/1/08       78              750

Hello all.  I always get such awesome help from you guys… so thank you in
advanced for any help!
Here is my problem.  I have a set of data in a flat table that is of course
related data.  I have been tasked with grouping information and counting

I have a table: (Dummy Scenario)
-Auto_number
-Employee_ID
-Name

In a table a have a datetime field called ’Time’ and I query records before
or after a specific time.
Example, three records with the following values in the 'Time' field
‘22-02-2008 10:23:31’

I have a Mac (OS 10.4) and I just bought Parallels Desktop for Mac. Does the
Microsoft Office Home and Student 2007 suite include an operating system and
will it work on my Mac?

hi guys,
this has really took lots of time from me and i wasn't able to solve it
i have written in my VBA codes this query:
DoCmd.RunSQL "insert into exister

Hi. I have a text field (each one with a different number of characters)
where some of the records at the end of their sentence contain "(CA)", or
"(CA", or neither one.
I need to find all the "(CA" records and change them to "(CA)", while