I have the following query that is supposed to show total hours but the hours
show up as 09:187 in the Total Hours: [THrs] & ":" & [TMin] part of the query.
How can I fix it?
Thank you.

any help with following much appreciated
Two tables, linked on ID
Table1
ID       CODE

I have a problem I have been trying to work out with several queries that
have the following date parameter so people can open the query within the
appropriate date range.

I haven't much luck in finding an answer to this in the community. I have
three related tables, Companies, Agreements, and Filings in an ACCESS 2002
SP3 database. I've modified one set of forms/subforms so instead of showing
all of the Filings for every year and other unneeded ...

Hello experts,
I'm trying to figure out the right syntax to do the following in SQLt:
if Field_Country  is equal to USA switch to "Y" as Address,
if Field_Country is not to equal to USA switch to "Z" as Address,

I have two tables with a one-to-many relationship, and i need to SUM all the
records of one field that link to each 'one' side for each record on the
'one' side. I can do this with a select query, but then I keep getting errors
in an update query I built to transfer that select ...

Here is my problem and I suspect this is a simple question for the
experts.
My query attempts to get the names of players that played in a game
during the past x minutes and then the average scores of that player

I want to run a query (append?) and then delete the records that were
appended. But I want to do this with one query instead of a macro.

I am trying to Sum my sales data by grouping all of the tranactions to the
quarter hour (rounding down to the quarter hour). For example assuming my
data looks like this...
05:22  100.00

Hi Froum
well I want to delete a set of rows from a table by joinin it with another
table but I get this error : "Could not delete from specified tables" but I
don't have any permission porblem because I can delete from each of these two

I have a delete query that delete all the record from a table. This query is
ran from a command button on a form through a macro.
When the process is completed.  It show "# DELETED" in all the fields of all
the records. But the records are physically still there. When I exit the

For a given field, is there a way to filter out all records that contain the
word "OLA"
Thank you in advance.

How do I installed Microsoft Word 2000 SR-1 DATA1.msi to my computer?.  I
can't used Microsoft Words without it being installed.
Please, I need your help.
Thank you

I really need some help!!!!
I have a list box displaying several items.  The same items are also found in
a separate table named: "FieldDescription". In this table, there are 2 column:
one listing those items and the other column contains the description of each

I have a table with a column that is fed by a sub-table with a auto number
primary key and another column with text. When I export a query based on the
table to Excel, the primary key is shown. How do I sow only the text
description?