On 20 Apr 2004 08:27:05 GMT, Sparro Chi wrote:
Thanks for ur help Hugo!..
The count for the actual will be derived from the a table where I can do
a count of the actual records where the date is <= the date I have put
in the table.
Hi Sparro,
This part is easy:
UPDATE YourTable
SET Actual = (SELECT COUNT(*)
FROM YourTable AS A
WHERE A.[Date] <= YourTable.[Date])
(untested)
And for the planned where date = the date in the table at those
intervals within a year!
I hope this makes sense.
Actually, it doesn't. It would help if you could post:
* the actual DDL used to declare the table (and any other tables
relevant to the question),
* illustrative examples of data in other tables relevant to the
question,
* desired output.
The preferred way to describe table structure is DDL (create table
statements), including all relevant constraints and indexes.
The preferred way to describe sample data is in the form of insert
statements.
If DDL ans inserts are posted, I'll almost allways copy and paste it
into Query Analyzer and test the queries I suggest. Without DDL and
sample data, I can only provide untested suggestions.
The preferred way to describe desired output is in a tabular format.
Make sure it's aligned properly when viewed with an unproportional
font.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)