When i have this i get many errors:

Server: Msg 207, Level 16, State 3, Line 16

Invalid column name 'GjelderFra'.

Server: Msg 207, Level 16, State 1, Line 16

Invalid column name 'GjelderFra'.

Server:...

I didn`t see the ,

But where shall i put the SELECT DISTINCT GjelderFra?

Morten

ANavn cannot be null see http://www.cyren.no/diagram3.gif 

Shall i only put the

            SELECT DISTINCT GjelderFra FROM marsh_HKL.tblhertzkorttidsleiebiler,

                        LEFT JOIN marsh_HKL.tblhertzkorttidsleieAvdeling 

                               ON FKBRAvdeling=AID --AND GjelderFra BETWEEN @datoFOM and @dataTOM

in the first select or...

Super!

Now i see some other small thing. It is stopping after year 2003 it should continue to the date today.

Thanks, Master Aaron

//Morten

Hi again Aaron!

Sorry that i have to ask you so many questions!

Everything looks good now except one thing. If you insert a car for each month the sum are pr...

Thanks for helping me i get an error, and im not very good at this somthing you are.

Server: Msg 207, Level 16, State 3, Line 54

Invalid column name 'ANAvn'.

Server: Msg...

Hi again!

I still have some problems, i`m not very good at this. Glad you are!!!! Thanks

Server: Msg 207, Level 16, State 3, Line 54

Invalid column name 'ANAvn'.

Server: Msg 207, Level...

Hi Aaron!

I still have som small problems with the query. The total sum are correct! Thanks!

It dosen't make the sum pr department(ANavn) It take alle togetheter pr month. Also if...

Hi again!

Server: Msg 207, Level 16, State 3, Line 54

Invalid column name 'GjelderFra'.

-- Get a listing of every month to be summarized

declare @Months table ( MonthGroup smalldatetime, MonthName varchar(25) )

INSERT...

Thanks for helping me. I get an error!

Server: Msg 156, Level 15, State 1, Line 9

Incorrect syntax near the keyword 'AS'.

Server: Msg 156, Level 15, State 1, Line 47

Incorrect syntax...

The problem is that there is over 15000 cars in the database. I dont want to make any changes. But make an query out of the data there is in...