Automatically 'Yes'

[Tansar]

Hello all,

I have a date field which is filled in by users when they take out the relevant material and a 'yes no' field, so other users can see if it is available or not.

Is there a way of automatically making the 'yes no' change to yes/no when the date field is filled in?

This I would like to know...TIA

 

[Mile-O]

You are essentially saying the the Yes/No field is a calculated field.

As you shouldn't store calculated/calculable values in a table but retrieve the value's by calculation in a query.

Make a calculated field like this:

LoanedOut: IIf(IsNull([YourDateField]), 0, -1)

 

[Tansar]

hmmm, a bit confused...you gave me a bit but I coudn't take it to a mile...anyway:

I have a DateOut field and next to it (in the query) I have the Returned field, which is the 'yes no'.

I tried the expression above (under the Returned field) and all the fields were blank...am I doing something wrong...(most likely)

Could you assist a little bit more please. Thanks!!

 

[Mile-O]

I'm saying "take out the returned field as you are saying that you don't need it."

Have a look at this attachment.

Are you not storing the date returned? If not, why? I would think that was more logical when loaning items is involved.

 

[Tansar]

Thank you...I see your point.

Date returned is not important in this case as it is an internal library, and if someone has a document their name comes up too.

So when a person takes out a doc they just date it and 'sign' it, from a drop down field (tblStaff).

Am I going the right way around this?

Thank you once again!!

 

[Mile-O]

I suppose, but when the item is returned are you clearing the date field?