2 gange SELECT COUNT(*) til en SELECT COUNT(*)

SELECT COUNT(*) AS Antalfo FROM " & username & " WHERE Followed > '" & fdays & "' AND Trash=0
UNION JOIN
SELECT COUNT(*) AS Antalark FROM " & username & " WHERE Followed < '" & fdays & "' AND Trash=0

.

Forget that, its going to give you two records and I guess you want one!

Nej jeg skal have 2 tal, 2 counts not one

SELECT (COUNT(*) FROM " & username & " WHERE Followed > '" & fdays & "' AND Trash=0) AS Antalfo, (SELECT COUNT(*) FROM " & username & " WHERE Followed < '" & fdays & "' AND Trash=0) AS Antalark

Så får du en record med begge counts.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '(COUNT(*) FROM Table1 WHERE Followed > '03-03-25-20-48-08' AND Trash=0)'.

Den ser nu også noget mærkelig ud

Der var lige smuttet en SELECT:
SELECT (SELECT COUNT(*) FROM " & username & " WHERE Followed > '" & fdays & "' AND Trash=0) AS Antalfo, (SELECT COUNT(*) FROM " & username & " WHERE Followed < '" & fdays & "' AND Trash=0) AS Antalark

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Reserved error (|); there is no message for this error.
/debat/top.asp, line 25

Den fylder også meget

Microsoft Access Driver?
This category is MS SQL Server!

Jeg har kunne bruge meget af det jeg har fået herinde alligevel

Der står MS SQL øverst og ude i oversigten og det har jeg gået efter

Den ser nu stadig også mærkelig ud

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver

???? It says Access here ????

jeg har kunne bruge det hele herinde fra indtil videre. Men jeg kan se at det er det forkerte nu når du siger det. Jeg flytter det til Acces! Hvis der stadig er nogle der har en løsning kan de finde det her:

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