Free Lessons Courses Seminars TechHelp Fast Tips Templates Topic Index Forum ABCD

 Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon More... What's New? Popular Links ------------ Access Courses Access Index Access TechHelp Access Forum Access Troubleshooter Access Developer Network ------------ Excel Courses Excel Index ------------ Code Vault Testimonials Tip Jar Advice for Consultants

 Home > Forums > Access
 Back to Access Forum    Comments List
 Achaiki Diachiristiki       3 years ago
Dear Richard
I am Vassilis from Greece and I would like to ask about a problem
I have a table with fields like Id. date field, numeric field etc.
What I would like is a query  that will show me the difference (DateDiff) of the days in the same column of the table as well as the difference (subtraction or addition) of fields in the same column.
 3 years ago I don't understand what you mean by "in the same column." Are you trying to calculate the difference between, say, two fields? Day1 and Day2? If that's the case just use query criteria and some math like:`NumDays: Day2-Day1`Unless I'm not understanding you correctly.
 Achaiki Diachiristiki       3 years ago Imagine a table with only two fields date and value, this table contains four entries. We asking the difference of days and values between entry [date] to entry [date] in the next line
 Achaiki Diachiristiki       3 years ago We are talking about only one field, it is called [date1] which should be compared to the same field [date1] in the next line of table (next entry)
 3 years ago So like this:`Date, Difference1/1/2000, NULL1/3/2000, 21/10/2000, 71/20/2000, 10`Where each line in the query shows the difference between the last date before it and the date in the record itself? You can do this with DMAX. If you can't figure it out let me know and I'll add it to the TechHelp list.
 Achaiki Diachiristiki       3 years ago I cant understand how the Dmax will detect the previous dateDmax(date,tablename,date =;;;;)Thanks
 3 years ago Easier to explain in a video. I'll add it to the list.
 Achaiki Diachiristiki       3 years ago ok thanks
 3 years ago Here you go: DMax

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.