Library Database

  • Thread starter Thread starter ozogeordie
  • Start date Start date
If this is your followup to my question about your previous post (where I
asked "What's the SQL of your query?"), when you have the query open, select
View | SQL View from the main menu. Copy all of that text, and post it to
the newsgroup.

By the way, please don't start a new posting each time. Repond to the
previous post, so that everything can be seem together as a single thread.
 
My SQL is as follows:

SELECT Loan.[Student Name], Loan.[Book Number], Loan.
[Loan Date], DateAdd("m",1,[Loan Date])+IIf(Weekday
(DateAdd("m",1,[Loan Date]),2)<6,0,8-Weekday(DateAdd
("m",1,[Loan Date]),2)) AS [Loan Due], Loan.[Loan
Returned], DateDiff("d",[Loan Due],[Loan Returned]) AS
DaysLate, Fines.finAmount
FROM Loan, Fines;
 
Back
Top