My table has a TimeInSec field (Time/Date datatype). This field has ALL
NEGATIVE numbers in seconds.
I used the following expression to change to regular time format.
Format ([TimeInSec]\3600,"00\:") & Format(([TimeInSec]\60) Mod 60,"00\:") &

I keep track of training sessions in a table.  I want to run a query that
will prompt me to enter in a Last Name, then First to list all training
sessions that person has attended.  Lost....too new to Access to understand,
but learning.  Ever so slowly.

I have three fields (all three text) in a table "a1", "a2" and "a3"
How can put all for a1 Plus (combine) a2 into a3 with a query?
Thanks

I've got a VB.NET app that needs to delete all the records from a
single, unlinked Access table.  The table has one field (non-key) of
type OLE object.  When I run the query   "DELETE FROM tbl_pics" I get
an error- "Could not delete from specified tables."  Anyone know what

Dear Sir / Madam
I'm Viveck from India.
I'm using office 2003 in MS Access i've got an Error, the message is Overflow
Please give me the quick reply.

I have a report that run a query which a user enters a date on a dialog box
and the report runs, which works fine. Here is the twist. The use want to run
the same query (Report), with the date in the critieria field (dialog box)
BUT, the user also wants to select a department as ...

    Good afternoon.  I've written several INSERT ... SET format queries for
my Access FE/MySQL BE, but Access will not let them through.  It reports
"syntax error," even with the dbSQLPassThrough option.
    I know my syntax is correct, because it works just fine at the console. ...

I have a field called Booking in Date and I need to subtract that from
1/25/05 to get a new field called Days in Jail. I am not sure how to go about
this. This is what I tried in my query and it returns #Error.
Days in Jail: [INMATE DATA 1-25-05]![Booking in Date]-"1/25/2005"

I have a few pass-through queries which execute SQL Server stored proc. After
I run these queries, Access slows down and become unresponsive - the only way
to get it to respond again is to reboot the machine!! Looking at my system
resources when this happens, everything seem to ...

Hi Group,
I have downloded Duane Hookom's excellent sample database for
Concatenating.  My problem is that it is set up to run with primary
keys that are numeric, however, my primary key is text number.  (It

Here's one that's bugging me, I'm developing a quotes system and I have a
table containing job quotes that can contain more than one record (version of
a quote) per quote number (I need to maintain a full audit trail of previous
quote versions)

This would be a great help if it can be solved.
I have 4500 applications for funding.
Each application must meet max 6 conditions to receive funding.
Applications are stored in tblApplication and conditions are stored in

I couldn't find any documentation concerning this topic.
I want to put a regular expression in an SQL query under Access. As for an
example, under Oracle, one can say:
"SELECT TelNumber FROM ... WHERE ... REGEXP_LIKE="[0-9]" ".

I have a table with a field "product_id".  The table has a lot of records
with the same "product_id", I would like to write a query that will delete
all the records with the same "product_id" except one.    I would like to
have just one record per "Product_id"

Hi to all,
I have an already query that uses SELECT ... UNION Statements to combine
fields in tow different tables( infos about Imported and Exported boards) in
this way: