Hi all, I am currently doing an access course but im only a little way through and in dire need of some proper help!!

I currently run a returns database here and would like to have an "outstanding returns" report. I can do the report no problems but I need it to somehow remove the returns that arent oustanding by looking in a field of a table I have running. Is this possible and am I actually making sense, I have brain ache!! :confused:

Thanks in advance

Sara

Just put IsNull in the criteria section of your date returned field of the query your Report is based on

Hi ya, I tried the IsNull thing but it says "Data type mismatch in criteria expression" any ideas what i am doing wrong? I am just doing a simple Query, is that wrong too ? :confused:

Edit to add: I did it! Just needed to add a space!