I have the following query: SELECT qryCapitalExpExclNonProject.ProjectName,
Sum(qryCapitalExpExclNonProject.[Deprn Amount]) AS [SumOfDeprn Amount],
Sum(qryCapitalExpExclNonProject.[Ytd Deprn]) AS [SumOfYtd Deprn],
Sum(qryCapitalExpExclNonProject.Cost) AS SumOfCost,

Probably a stupid question:
when I add tables to my queries, they are joined by lines.  Usually they are
just straight line.  If I do an outer join,  one end of the line has an
arrow.  so far so good, I understand all that.

I have a query which is taking a while - and maybe that's ok, but I wanted
to make sure.
I have a table L which contains roughly 73000 records.  I have another table
M which contains roughly 11000 records.  Both tables have an ID column (F1

I'm running Access 2000.
I have a (messy) query which outputs Part_No and Voltage2, and Access
will display the datasheet view without a problem.  Part_No is unique
in this result.

[Sorry to re-post this, but was offered one solution before by
Vanderghast a while ago telling me to look at
http://www.mvps.org/access/queries/qry0016.htm, but that didn't seem to
do exactly what I wanted (or I couldn't implement it!). Wondered if

I want to select the contents of 2 different tables into a new table.
I am doing something like:
SELECT T3.* INTO tblNEW
FROM

I have 400 names in a table (7 fields)I made a query of 40 names from that
table. Can I now make a table from that query. I used the "create table"
wizzard but, can't do it. It looks like no relationship can be formed between
the query and the proposed new table. It seems like I ...

We have checksum function in sql server 2000,i would like to implement
same in .Net.Can some one provide checksum algorithm.
Thanks
ManDev.

Hi ;
I keep getting a "Syntax error in Insert" message when I try to execute the
following.
dim holdFlNme = "c:\myWorkbook.xls"

I'm trying to get a DateDiff expression in a query to result the subtraction
of time2 and time1, but when in the query the result doesn't showup until its
clicked and is negative. Here is the expression DateDiff ("n", [time1],
[time2]) . I'm a newb at access so any info would ...

I have setup a letter which is sent out to customers who have been set with
a service reminder date (held in tblservice) which works well, But I have
thought of a problem whereby if they are printed off daily religiously then
there could be problems. So I thought that I should ...

I need help with a query for a DB that has over 1 mil records.  The DB
contains over 30 regions and I want the query for 50 records only for each
region.  Can anyone help?

I have the following update query
UPDATE tblcustomers INNER JOIN tblservice ON tblcustomers.ID =
tblservice.CustomerID SET tblservice.ServiceReminderSent = False
WHERE (((tblservice.ActDateCompleted) Is Null));

Hopefully, someone can help me with the design of the way a table looks from
a query.
Lets say I have a table that has 10 rows of member and providerinformation
in it.   However, there are ONLY 5 doctors.  Some of the doctors have more

I have a table that has a unique Key for each row of data.  I  need a way for
the users to copy a row of data using a query.  Is it possible?   The
application is contains historical information  and the users want to be able
to open a form and then have the option to copy data ...