Here is my question I'm using ACCESS2010.  
I am building a QUERY and attempting to insert a calculated field that resembles the data fields below.  
[DATE0] [RESULT1]  [DATE5]  [RESULT2]
I need to see the difference between [RESULT1] and [RESULT2] based on a specific set of dates.  
I inserted a calculated field using the builder [DATE5] (original date minus 5 days) Works fine.  THE PROBLEM:  when I attempt to create a field that equals [RESULT2] WHICH is or should be the  ( [RESULT2] = [DATE5] is get a zero.  
My goal is to be able to locate the difference in [RESULT1] and [RESULT2] based on an OFFSET of X Days.  In this case 5 days.  
Im usually very good at this stuff, but in this case Im stuck.  I used the BUILDER, no luck.  I still get the result of zero.  
What class should I purchase that will show me how to resolve this issues and tell me what Im  doing wrong.  
Regards,
Paul

---

Reply from Richard Rost:

I can't wrap my head around your question. Can you ask it again using a generic example and perhaps show me some data? Your field names are doing nothing for me. Sorry.