M$ access problem

[Alliandre]

Ok. This is the best place I could think of to post this. Need to try and do this for my school c/w so I hope someone can help

I would I go about displaying yes or no based on whether or not there is a date entered into another field?

Thanks in advance.

 

[wyrd_fish]

use VBA

ok, maybe it isn't all that simple, i've been playing with it, and it won't work

it would seem, that it doesn't knowtice when there's no value

 

[SilverHood]

Don't think you can do that without using VB (need a select statement, if date == null, then, etc). I have never studied VB, so can't help you

You can however, use the "is null" in the criteria field - if there's no value, then it won't display records without a date
Or alternatively, use the "is not null" in the criteria field, to show only records with a date value.

Best I can do

 

[wyrd_fish]

VBA, the version you get with Access, doesn't use ==, its dead simple

ah, tried again, i can't get it to work

 

[SoWat]

I haven't used VBA for a while, but you might want to try something like -

StringVariable = Nz(DateField, "No")

DateField would be the field where you're checking for dates.

Obviously StringVariable would then be used for filling in the field, or whatever it is you want to do.

Good luck!

 

[dan]

It depends which language you are using. If your accessing data in the database using SQL statments then the return from the query will be NULL.