I have a labour value in pounds stirling, and my labour rate is £10.97
per hour - and want to convert this into hours and minutes. Any help
would be appreciated.
Alec

I would like to do a Summation with lower bound of summation 0, and n is the
upper bound of summation. Could i used it in a queryBuilder?

I have a subform that has a combo which
selects filtered records.
The combo has a field "ItemPrice" which has
lost the currency format, but this format is

I am new to Access 2007.  In previous versions of Access, I was able to run
an update query to place carriage returns in place of square box characters
that were showing up after importing Excel spreadsheets into the database
(Article ID 210372).  Unfortunately this solution does ...

Helpdesk calls are logged in 2 tables, 'Calls' with 1 row per call, and
'CallActions' with a variable number of entries per call log.  The schema for
CallActions is:
CallID, ActionID, datestamp, narrative

I have a table:
Tader              Entry_date
Allen                 1/Jan/2008
Steve                1/Jan/2008

I have an append query that I want to run until there are not more records to
append. Any idea how can I write a procedure or a macro.
I used the RunMacro command but the exprression is not correct; please help
me.

I have 2 tables and I'm trying to run a query that runs iff() statements by
comparing columns from each table and returning True or False if they are the
same.
e.g. Using tables Person and User -

I am using a query that sellects transactions by vendor... there are two
fields [Credits] and [Debits]  These are sorted by date... I would like to
have and expression that makes a running total of these two fields.. I would
then like to us this expression in a report..

I have a field that looks like this:  12/TX-Dallas
I am hoping to extract out only the sales office, in this case it's Dallas.  
I tried the =right([sales office],35) thinking that there would be no sales
office larger than 35 characters.  that didn't work.

I have a database with a number of M2M relationships, which I have gathered together in a very long query
which I use to build an ADO recordset for one "record". Is there any way I can run queries on that recordset?
I want to remove duplicate entries in specific fields.

I'm relativly new at access and ran into some issues.
Question 1:
I'm in a make table Query and would like to create a new column with a
specific date (02/10/2008) in every row of that column (Note: I would like to

I have 2 table
Stock_Table
Take _Table
Stock_Table Contain This Field

I have a query with several fields. I want to be able to filter a specific
field for unique values.
Let me explain :
Field Name : Circuit ID

I am trying to manipulate a contact table (Id,FirstName,LastName,
Address,City,Prov,PostalCode,Phone1,Phone2,Email,...)
In the table I can have, and do have, multiple entry for a given postal
code.  Basically, I have an entry for a Husband and another for the Wife.