I'm relatively new, so I'm not sure if what I'm asking is possible, but I
certainly am hoping...
Scenario 1—
I have two tables-  

In my query I would like to add two fields from one table:
[DateOfEntry] i.e. 12:40 PM
[TotalMinutes] i.e. 30
I realize that the [TotalMinutes] has to be divided by 60 but cannot make

I have a form that will be used to update and add records to a table, pretty
straight forward stuff.
I've been getting an Error every time I try to add a record.
"The changes you requested to the table were not successful because they

I have put together a query which looks up a date range using the Between
And function. If though i put in a date which is not valid ie. 31/06/07 all
records are returned. Is there a way i can put some form of validation in to
avoid this happening?

Hi.  I think I'm got Subqueries (semi-) figured out...
except for one I'm trying to create now.  I want to search for owners of
properties.  The owners are in a subform on the main property form.  It
works, however I would like the search to run on partial results.  i.e. if I

I try to create an interface to display records/ or posting message on
a form when I select  data from a table which meet the combo box
values to diaplay on a form, however, sometime data of combination of
two combo boxes are not exist..

I have created a database to use at work for keeping record of orders,
shipping details etc.  This is to assist in prediciting cashflow etc.
My problem is, I have created a form for Indirect shipments and a form
for direct shipments, which the information for both is linked from

I have written the following function and I want to use it in the
criteria of a query. However, when placing "BaseFacility()" without
quotes in the [FAC_ID] field's criteria  nothing is returned.
Please help. Thank you.

Is there such a thing as a cascade copy? I know there's cascade delete where
if you delete the main record, all related subrecords are deleted but what if
I want to do the reverse. For example I have a quote that has subpackages
related to it. If I want to copy the main quote, I ...

I have a table with employee names and training courses they have been on.
I have created a second table which has a training profile for each job
type, so for example Social Workers need to attend the Diversity course,
Manual Handling, the Induction course so on.

I'm using the following function which I found on another site.
Public Function DMedian(FieldName As String, _
                   TableName As String, _
                   Optional Criteria As Variant) As Double

I have 2 tables - a main table (tbl_Opportunity) and a look-up table
(tbl_AMContacts).  I have a field in each (AllianceMgr) that links the two
tables together (AllianceMgr is the primary key on the AMContacts table).  
I'm trying to do a query that combines all of this data ...

I'm currently using MS-Access to write reports using a SQL Server db as the
data source in a client/server arrangement.
The database is sufficiently large (2gb) that data retrieval speed is an
issue.

Which of GROUP BY and DISTINCT is the quickest? and why?
Thanks for any relevant answer!
PS: Please don't tell me that there is no difference because it's a matter
of one millionth second.

My query looks like this:
SELECT Diptera.ID, NZ([Species],[Subgenus]) AS Name INTO [synonym]
FROM Diptera;
I get a compile error.