I have been trying to figure out how to get my query to round the hours to
the nearest 1/2 or quarter hr.  One of the problems I have is that we use the
following break-down for quarter & half hours:
7:15 would be 7.25hrs

i have a questing relating to sql, i have a table that has student
enrollment, and i need to find out how many students have enrolled in
the same number of subjects as that of student who's id is '0102',
note the subject could be different , but the final number ie. count.

I have a database, which at the moment I export into excel to achieve my
goal.
I have a table of email addresses under the field heading "Email", from
which I want to select a random email address "For a monthly draw", is it

what expression should I use to convert text, formated as date (01/01/2000)
into a date data type?

I am making a calendar which has a table of all the days & another with
birthdays + I want to be able to print out a report combining both tables but
the 1st is a full date & the 2nd is just dd mmm. I want the birthdays table
to go into every year, for example Joes birthday is ...

hi, table as follows:
ID          DESC    VALUE
======================
1    g56    7

Employees accumulating seniority : 200 days = 1 year
If an employees has accumulated 278 days, I would like to show it as 1 year
78 days.
The following formula would do the job :

I want to use an expression in an update query to add text to the already
existing text in a field, but I do not want to change the field name or
create a new field to accomplish this.

Am trying to construct a query to generate a histogram an the
distribution of a variable TimeDiff that is defined in a query ART.
I defined a table called HoursBin:

Hi all, I would really appreciate any feedback on this problem as it
has had me stumped for a long time now!  I am using Access 97 as a
front-end to a DB2 database and i'm trying to create a query which will
return results from the DB2 database between certain date values.  When

Am regularly running into a problem where something snaps and an append
query stops running with the captioned error message.  I'm not doing any
math calculations, just appending selected fields from a filtered record
set.

I wonder if anyone could point me in the right direction. I am trying to
query someone else's table & can't do what I need to.
The table contains sveral Price fields eg CDPrice, AirConPrice, SatNavPrice
etc. In the same table there are also Yes/No fields for each of these fields

I have a database where I regularly import refreshed tables. The tables
show employees whose records have been rejected in a sync run between
SAP and a mainframe.
Some of these employee records are not worth fixing... ie, employees

My query has several fixed filters and one using "NOT RIF*".  The results I
get when I run it in Acess are correct and expected.  When I use that same
query to mail merge in Word, the "*" records are included.  How do I fix this
so that the merge run lwith the data in the Access ...

How do I do a query which will only pull up the last time we went to a
location and retrieved data for one specfic field in the database.