Re: expression and new field on query
From: Marko (ozogeordie_at_hotmail.com)
Date: 03/31/04
- Next message: Tom Ellison: "Re: Missing Numbers"
- Previous message: Tom Ellison: "Re: Find duplicates - multiple column combination"
- In reply to: JulieD: "Re: expression and new field on query"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 31 Mar 2004 11:12:50 -0800
Hi there what you said has helped but you did not answer
my other questions:
How would I make my database be able to record the
renewal of a book by a student?
What expression could I use to prevent a book from being
renewed more than twice by the same student?
I do not have a renewed field I would like to add it to
my Loan query with the others I just need an expression
to do so. Any ideas?
Many Thanks
Marko
>-----Original Message-----
>Hi Marko
>
>a criteria of IS NULL under Loan Returned
>in the query will show those books that are still "out"
>
>or IS NOT NULL under Loan Returned in the query
>will show those books that have been returned and are
therefore available
>for loan. You could then base a form on this query as
the only books that
>will display on the form are those that are available
for loan.
>
>Hope this helps
>Cheers
>JulieD
>
>"Marko" <ozogeordie@hotmail.com> wrote in message
>news:138dc01c4173c$cc33cd00$a601280a@phx.gbl...
>> HI there, I currently have a database which records
book
>> Loans.
>>
>> I am creating a Loan query which currently has the
>> fields:
>>
>> Student Name
>> Book Number
>> Loan Date
>> Loan Due
>> Loan Returned
>> Days Late
>> Fine Amount
>>
>> What expression or form of validation could I use to
show
>> only books available and stop anyone taking out a book
>> which is out on loan.
>>
>> and
>>
>> What expression could I use to prevent a book from
being
>> renewed more than twice by the same student.
>>
>> I do not have a renewed field I would like to add it to
>> my Loan query with the others I just need an expression
>> to do so.
>>
>> if this helps my table relationships are:
>>
>> STUDENT LOAN INSTANCE BOOK
>>
>> Student Name Student Name Book Number ISBN
>> Age Book Number ISBN Author
>> Class Loan Date Instance Number Genre
>> Loan Due Department
>> Loan Returned Age Group
>> Fine Publisher
>> Book Title
>>
>>
>>
>> Thanks
>>
>
>
>.
>
- Next message: Tom Ellison: "Re: Missing Numbers"
- Previous message: Tom Ellison: "Re: Find duplicates - multiple column combination"
- In reply to: JulieD: "Re: expression and new field on query"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
