vertical dates

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

I have a table with dates. I need to have it look down the table to the next
record and if its within five days add two dollar amounts together.
 
How do you handle the following dates? All five dates are within 5 days
of 12/4/2008.

12/1/2008 1
12/2/2008 1
12/4/2008 3
12/7/2008 3
12/8/2008 4

Are the two dollar amounts in the same record or in different records?
Are they even in the same table?

You need to supply more information.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average Inventory 2
Omit groups of records that don't meet criteria 2
Problem Sequentially Numbering Records 2
Update Table with query 3
Reference previous record 5
Querying Dates 5
Dcount returning no results!!! 0
Find Replace values when they are not null 3

Back
Top