Queries With Database 2007

Hvad markerer "active records" fra "non active records"?

Hi salim..
If you have a Yes/No field which indicates if a record is active or not you can make an SQL query somethng like this

SELECT *
FROM YourTable
WHERE SomeField=True

That give syou the active (true) records, and the non active

SELECT *
FROM YourTable
WHERE NOT SomeField=True

Thanks alot terry for your reply but though...i did not get it ...Well i have a called student_details which contains fields like Cpr, first name, last name...and so on...but i am using a ADODB connection...which links to another Db...Basically DB is designed to suite the need for a Uddanelse Center...in which students comes daily to the center types their CPR and press the button Chekin...the other DB is on the server which contains the Students_Checin Table...in which i will get a time stamp of users login...with date...but let us say some day particular student is absent...then how can i get a report for students who where no checkedin...
Best Regards,
Salim...

Hi Salim
If both tables were linked into your Access database then you would be able to make a query which joins both tables. This would allow you to find records in student_details which dont have a matching record in the Students_Checin Table (for specific date).

If you cant make make a query which does this, because of your setup then you could maybe make a TEMP (local) table which reads all of the records from tudents_Checin Table into the TEMP table. Thne you couls make the SQL query you need.

Hows it going Salim, do you need mre help?

Well terry i am stuck at one stage...
i will send you my database itself... can you gimme your email ?
i guess its difficult like this to understand...

ekspertenATsanthell.dk
AT = @
and an explanation as to where your having problems please

Thanks...but are you going to charge ? or for free?

;o)
Its a question you have placed in eksperten so its free but if you want other work done then you can contact me through my email.

Maybe my explanation could be better.

If you send me your dB I will try and find a solution to this question for free. If you need help with other problems then you can contact me through my email where I can give a quote. Or you can place another question on eksperten and see if you can get help (for free).
Hope that helps

Hey Terry..
Hope you received my DB...
If any questions better mail me....
Waiting for the solution....
Thanks for the Help...

Terry Can you help me..i dont know how to close the question...

Du skal markere terry's i boksen nede til venstre og dereftr trykke på accepter.

http://expfaq.dk/

I'll need to place a new answer first.

isit closed now?

Yes it sclose dnow, thanks salim.
Do yo still need help on the last mail you sent me concerning prices?