This should do it - uses a co-related subquery:

select t.b, t.d, t.c,

Calc = case t.b

when 'yes' then t.c / (select cast(sum(t2.c) as decimal(19)) from A t2 where t2.d =...

Have you tried a full reboot of the server?

Has anything been installed on the server recently?

Assuming that's all you want ...

SELECT MIN([DATE]) FROM STOCK_MOVEMENT_HISTORY

If you actually want more than that, please post an example of your required results.

Check this article & see whether it's relevant:

http://support.microsoft.com/kb/885442

No it doesn't.

From BOL:

COUNT(*) returns the number of items in a group, including NULL values and duplicates.

COUNT(ALL expression) evaluates expression for each row in a group and returns the number...

This is a weird one.  Have you run dbcc checkdb?

Also, if you run the statement directly through QA (rather than as part of a stored proc), do you get the...

As soon as you put a count() in your query, SQL Server assumes that you are attempting to summarise your data in some way.  In particular, it assumes that you...

Have you tried using DTS?  That should do it.

If you are using QA, check out the value of Tools/Options/Results/Maximum characters per column.

I am not familiar enough with Access projects to give you a definitive answer here.

Is the selection method something which you have control of?  Or is it an off-the-shelf Access...

Even though they are sharing the program, they are not sharing processes.  Is the selection you are talking about performed at run time, or is it driven by data which...

Are you concerned that multiple user access will cause locking problems?

When you talk of a user's records showing up on other users' reports, what do you mean?  Do users own certain...

Check out INSERT INTO and SELECT INTO in BOL - they will both insert records into a table.

Don't know, but your query could be rewritten using joins:

delete ta

from TaxAddress ta join Parcel pa on ta.parcelid = pa.parcelid

join CvtMadParcel cmp on pa.userdefinedid = cmp.parcel_no

where pa.taxyear = 2004

Might be...

Thanks Sushila.  I think that my main difficulty here is that I need the ranking (1-5 date desc) built in to the query and I cannot see how to do...