RE: Creating expressions
From: Eric Butts [MSFT] (ebutts_at_online.microsoft.com)
Date: 03/29/04
- Next message: anonymous_at_discussions.microsoft.com: "Undefined function in expression error"
- Previous message: Karen: "Re: Query for all Journal entries per CaseID"
- In reply to: Book Man: "Creating expressions"
- Next in thread: Book Man: "RE: Creating expressions"
- Reply: Book Man: "RE: Creating expressions"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 29 Mar 2004 19:02:35 GMT
Hi,
Here's SQL Syntax that could be the RecordSource for your Form "Books
Available":
SELECT * FROM [your table name] WHERE [Loan Date] Is Null;
I'm not sure about the "renewed more than twice by the same student" part.
If you have a field in your table that records the renew times maybe.
Example:
Student Name
Book Number
Loan Date
Loan Due
Loan Returned
Days Late
Fine Amount
RENEWED
Use an update query that would increment the field "RENEWED" by one. Then
have a query that would return the records where it was renewed 2x or more
SELECT * FROM [your table name] WHERE [RENEWED] >= 2;
I hope this helps! If you have additional questions on this topic, please
respond back to this posting.
Regards,
Eric Butts
Microsoft Access Support
ebutts@online.microsoft.com
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."
This posting is provided "AS IS" with no warranties, and confers no rights
--------------------
| Content-Class: urn:content-classes:message
| From: "Book Man" <michael.anderson@lineone.net>
| Sender: "Book Man" <michael.anderson@lineone.net>
| Subject: Creating expressions
| Date: Mon, 29 Mar 2004 08:04:05 -0800
| Lines: 24
| Message-ID: <124d901c415a7$75f79ca0$a601280a@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcQVp3X1ewghvZ8UT3efzpEThkuysg==
| Newsgroups: microsoft.public.access.queries
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.queries:195639
| NNTP-Posting-Host: tk2msftngxa14.phx.gbl 10.40.1.166
| X-Tomcat-NG: microsoft.public.access.queries
|
| 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 so only
| books not on loan can be borrowed.
|
| and
|
| What expression could I use to prevent a book from being
| renewed more than twice by the same student.
|
| Thanks
|
|
- Next message: anonymous_at_discussions.microsoft.com: "Undefined function in expression error"
- Previous message: Karen: "Re: Query for all Journal entries per CaseID"
- In reply to: Book Man: "Creating expressions"
- Next in thread: Book Man: "RE: Creating expressions"
- Reply: Book Man: "RE: Creating expressions"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
