sql query help

[eddy_245]

hey, this is probably really simple but i can't do it :s
anyways in my database i have a table which i would like to query, the fields in the table are Box ID, Box Size and Contract ID. i wish to display the fields where the contract ID is empty.
so far i got -
SELECT *
FROM tblBoxType
WHERE Contract ID=
then i am unsure what to put after the = as everything i seem to enter either diaplys all the fields or says missing expersion.
would be really greatful for any help thanks.

 

[raskew]

Hi -

Try this:

SELECT *
FROM tblBoxType
WHERE [Contract ID] Is Null;

HTH - Bob

 

[eddy_245]

that did the trick, thank you very much