473,320 Members | 1,933 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Access Date calculation

We need to track how often a book has been loaned. We enter the dates
and need an automatic calculation how often in the preceeding 12 months
it has been taken out. box 1: today's date box 2: loaned n+1
How do I go about this please?
Lindie

Nov 13 '05 #1
3 2716
<Li****@magichans.com> wrote
We need to track how often a
book has been loaned. We enter
the dates and need an automatic
calculation how often in the pre-
ceeding 12 months it has been
taken out. box 1: today's date box 2: loaned n+1 How do I go about this please?


If you will clarify what data you _keep_ about the book and loans, not just
what you want to _return/calculate_, someone may be able to offer a useful
suggestion.

If you only have one record per loan and it contains the checkout date,
you'll insert today's date as criteria for the date field, and use the count
function on a field that is not null in any record... but you may be using
different information to track book loans.

Larry Linson
Microsoft Access MVP
Nov 13 '05 #2
Thank you Larry for suggesting some more clarity from me.
A particular event occurs: a book is loaned
this happens on a particular date DateY
This book has also been loaned on previous dates

What we need is when we enter date Y is for the total number of times
the book has been loaned out in the previous 12 months.
something like [number of loans over (today-12 months)]
Lindie

Nov 13 '05 #3
Larry,

Just thought through your suggestion about using the date. This we
could do because there is a date every time a book is loaned. I am
stuck though as to where to go from there. You mentioned there not
being any '0' records but there will be. Some weeks a particular book
will remain on the shelf.
Using a count function- whatever that is- may not work.
Sorry to be more than a little dense.
L

Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Richard Hollenbeck | last post by:
I'm trying to write some code that will convert any of the most popular standard date formats twice in to something like "dd Mmm yyyy" (i.e. 08 Jan 1908) and compare the first with the second and...
6
by: Michael Bulatovich | last post by:
I have a very simple db I use for keeping track of hours, tasks, projects, clients etc. It has a form that I use to enter data. Currently the form has a textbox for a field called "start time",...
15
by: Pres | last post by:
I am not an experienced programmer. I do have a question regarding workday calculations. I have 3 fields. CURDATE, NUMDAYS, CALCDATE After entering the first two fields, normally the current...
4
by: JMCN | last post by:
object invalid or no longer set - confusion of the recordset in access 2003. i am currently converting from access 97 to access 2003. majority of the codes converted over perfectly fine, though...
8
by: John Beeler | last post by:
I am a graduate student writing a thesis on a space in Indianapolis called the Circle. I'm trying to figure something out that would really help me out as I write this thing. I would like to...
14
by: Crimsonwingz | last post by:
Need to calculate a sum based on a number of factors over a period of years. I can use formula ^x for some of it, but need totals to carry over in the sum and have only been able to do this thus...
3
by: audleman | last post by:
I've been programming in Filemaker and am used to having a field type called Calculation. An example of a calculation: In a school registration database I have a date field corresponding to the...
1
MMcCarthy
by: MMcCarthy | last post by:
Access has a number of built-in functions which can be generally used in queries or VBA code. Some of the more common ones are: Note: anything in square brackets is optional Date Functions ...
15
by: Widge | last post by:
Hi, I wondered if you could help me with an issue I'm having. Currently I have a rebate calculation that is running off two tables: 1) A list of suppliers and the rebate %ages relevant to them...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.