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

 Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon More... What's New? Popular Links ------------ Access Courses Access Index Access TechHelp Access Forum ------------ Excel Courses Excel Index ------------ Code Vault Testimonials

 Home > Forums > Access
Access Forum
Achaiki Diachiristiki
18 months 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.
 Richard Rost 18 months 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 18 months 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 18 months 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)
 Richard Rost 18 months 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 18 months ago I cant understand how the Dmax will detect the previous dateDmax(date,tablename,date =;;;;)Thanks
 Richard Rost 18 months ago Easier to explain in a video. I'll add it to the list.
 Achaiki Diachiristiki 18 months ago ok thanks
 Richard Rost 18 months ago Here you go: DMax

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Start a NEW Conversation
 Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

 You may want to read these articles from the 599CD News:
 8/18/2022 Access Developer 41 8/18/2022 Access Developer 41 8/18/2022 Access Developer 41 Lessons 8/18/2022 Event Countdown 8/17/2022 Access Developer 40 8/17/2022 Append Mistake #2 8/16/2022 System Font Dialog 8/16/2022 RGB to Hex 8/16/2022 Hex to RGB 8/16/2022 Choose Color Dialog

 Learn  Access - index Excel - index Word - index Windows - index PowerPoint - index Photoshop - index Visual Basic - index ASP - index Seminars More... Customers  Login My Account My Courses Lost Password Memberships Student Databases Change Email Info  Latest News New Releases User Forums Topic Glossary Tips & Tricks Search The Site Code Vault Collapse Menus Help  Customer Support Web Site Tour FAQs TechHelp Consulting Services About  Background Testimonials Jobs Affiliate Program Richard Rost Free Lessons Mailing List Order  Video Tutorials Handbooks Memberships Learning Connection Idiot's Guide to Excel Volume Discounts Payment Info Shipping Terms of Sale Contact  Contact Info Support Policy Email Richard Mailing Address Phone Number Fax Number Course Survey