Need help creating library report

[iansan5653]

I just became the librarian for my Boy Scout troop, and we needed a Database to track the books (available, overdue, etc.)



So here is what I have so far:
I have 1 main table (Books) with fields: book name (text), published date (yyyy), and base cost (U.S. Currency).

I also am going to have 1 table for each book to track who checks it out with the fields: first name (text)*, last name (text)*, email address (text)*, phone number (text), checked out* (Short Date), Due Date (short date calculated: [checked out]+14), returned (Short Date), and available (Yes/No calculated: IIf(IsNull([returned]),False,True) )

Now what I need to do is create a report with one line for each book (that is the easy part, I will just use the fields in the main table). The only other data I want on that report is a column of checkboxes showing what books are available. The problem I am having is getting only the last checkbox in each of the books tables to show on the lines of their respective books. I also want to do the same type of thing and detect the overdue books. So ideally I would have a report like this:

<table border="1" bordercolor="" style="background-color:" width="100%" cellpadding="3" cellspacing="3">
<tr>
<td>Book Name</td>
<td>Date Published</td>
<td>Value</td>
<td>Available</td>
<td>Overdue?</td>
</tr>
<tr>
<td>Book1</td>
<td>1999</td>
<td>$6.00</td>
<td>No(unchecked checkbox)</td>
<td>No</td>
</tr>
<tr>
<td>Book2</td>
<td>1997</td>
<td>$3.00</td>
<td>Yes(checked checkbox)</td>
<td>No</td>
</tr>
<tr>
<td>Book3</td>
<td>2011</td>
<td>$9.00</td>
<td>No(unchecked checkbox)</td>
<td><span style="color:red;font-weight:bold;">Yes</span></td>
</tr>
<tr>
<td colspan="2"></td>
<td>$18.00</td>
<td></td>
<td><span style="color:red">1 book(s) overdue</span></td>
</tr>
</table>

view HTML using Draacs HTML tester. I can generate HTML for the tables too, if needed.

[June7]

This is an Access site. If you need help with html web code need to post question in an approrpriate form. Check this one out http://forums.aspfree.com/html-javas...nd-css-help-7/

1 table for each book - bad design!

You might look at the MS Lending Library database template http://office.microsoft.com/en-us/te...010206883.aspx

[iansan5653]

Just to let you know, I wasn't asking about the HTML, that was just the easiest way to show the example. I will check out the database you sent.

Thanks, Ian

[iansan5653]

OK, so this database was the perfect fit, exactly what I wanted. One last thing, and this does have to do with HTML/web designing. Is there a way to embed a report (not the entire database) into a wordpress.com blog? I want it to be updated every time the page is refreshed. This way all the members of the troop can see what there is to be checked out.

I looked at report snapshots, but I don't understand how that works, and I don't know if it will automatically update.

[June7]

Here's how to show tables in forum post
https://www.accessforums.net/forum-s...post-2869.html

Have no idea how to get dynamic report onto web page. Now you really do need to check out another forum.

[iansan5653]

OK, Thanks. I think that is probably going to need to be a new post altogether.