omdøbe tabel samt forespørgsler!

http://www.eksperten.dk/spm/204265

SpeedFerret

http://www.moshannon.com/

You dont need to!

SELECT * from [count].....

but it is obviously best to NOT use reserved names!

bentbent you still have an open question here http://www.eksperten.dk/spm/417204

Tak for de gode bud, jeg prøvede SpeedFerret som virkede rigtig godt, men den kunne desværre ikke finde ud af at erstatte "count"!

Da jeg snart har prøvet i over 3 timer at få det til at du, ville jeg høre om nogle af jer kunne omskrive nedenstående:

tabellen "count" hedder ny "countlog"

På forhånd tak!

1...........................

SELECT count.IP, count.Referent, count.Browser, count.Sprog, count.Host, count.Tid, count.Dato, First(DateDiff("d",[dato],Date())) AS nrdays, Format$(count.Dato,'ww yyyy') AS Week, Format$(count.Dato,'yyyy') AS [Year], Format$(count.Dato,'mmmm yyyy') AS [Month], Format$(count.Dato,'Long Date') AS Days, Format$(count.Dato,'"Kvt"q yyyy') AS kvar
FROM [count]
GROUP BY count.IP, count.Referent, count.Browser, count.Sprog, count.Host, count.Tid, count.Dato, Format$(count.Dato,'ww yyyy'), Format$(count.Dato,'yyyy'), Format$(count.Dato,'mmmm yyyy'), Format$(count.Dato,'Long Date'), Format$(count.Dato,'"Kvt"q yyyy');

2............................
SELECT DISTINCTROW count.Browser, Count(*) AS nrofcount, [Nrofcount]/((Select count(*) from [count])/100) AS pct
FROM [count]
GROUP BY count.Browser;

3............................
SELECT DISTINCTROW Format$(count.Dato,'Long Date') AS Days, Count(*) AS nrofcount, [Nrofcount]/((Select count(*) from [count])/100) AS pct, First(DateDiff("d",[dato],Date())) AS nrdays
FROM [count]
GROUP BY Format$(count.Dato,'Long Date');

well taht wasnt the original question bentbent but none the less

SELECT countlog.IP, countlog.Referent, countlog.Browser, countlog.Sprog, countlog.Host, countlog.Tid, countlog.Dato, First(DateDiff("d",[dato],Date())) AS nrdays, Format$(countlog.Dato,'ww yyyy') AS Week, Format$(countlog.Dato,'yyyy') AS [Year], Format$(countlog.Dato,'mmmm yyyy') AS [Month], Format$(countlog.Dato,'Long Date') AS Days, Format$(countlog.Dato,'"Kvt"q yyyy') AS kvar
FROM [countlog]
GROUP BY countlog.IP, countlog.Referent, countlog.Browser, countlog.Sprog, countlog.Host, countlog.Tid, countlog.Dato, Format$(countlog.Dato,'ww yyyy'), Format$(countlog.Dato,'yyyy'), Format$(countlog.Dato,'mmmm yyyy'), Format$(countlog.Dato,'Long Date'), Format$(countlog.Dato,'"Kvt"q yyyy');

2............................
SELECT DISTINCTROW countlog.Browser, Count(*) AS nrofcount, [Nrofcount]/((Select count(*) from [countlog])/100) AS pct
FROM [countlog]
GROUP BY countlog.Browser;

3............................
SELECT DISTINCTROW Format$(countlog.Dato,'Long Date') AS Days, Count(*) AS nrofcount, [Nrofcount]/((Select count(*) from [countlog])/100) AS pct, First(DateDiff("d",[dato],Date())) AS nrdays
FROM [countlog]
GROUP BY Format$(countlog.Dato,'Long Date');

what would we do without notepad :o)