Search results

OK. I figured it out. I simply grouped my last query by date, by difference and used the "Min" function in the total row to get my answer. Now I have to broaden my date range consideribly. If I have any problems I'll be back on here begging for help again...

KeithG, Thanks for the quick response! I don't know if I followed you exactly but I was able to get very close to my final result. The only problem I get now is a duplicate on 11/12 because its the same number of days between 11/5 and 11/19. I don't want any duplicates and I would prefer for...

I need to find the nearest dates between two tables. Table1 contains dates 11/1/2006 to 11/30/2006 Table2 contains only two dates: 11/5/2006 11/19/2006 I want Query1 to produce the nearest date in Table2 beside each of the dates in Table 1. Example: Date Nearest Date...

Thanks for pointing me in the right direction. I appreciate the help.

Rich, Thanks for you reply. To be perfectly honest. I don't know what I doing yet. I'm attempting to learn on the fly. I am trying to explore what I can and cannot do. My new job is requires me to do almost everything through Access 2000 and SQL Server 2000. Most of the work has been done...

Neil, Thanks for the repsonse. I am new to Access and I am trying to learn how everything works. Let me take another stab at the question. I have a "new" table that uses a make-table query to update the information that is coming from a "main" table that has information being fed by a data...

How can I get a make-table query to run in a report?

As raskew pointed out the correct time should have equaled 2330. Thank you both for replying to my question. I will give The_Doc_Man's words of advice a shot and see what happens.

Clarification My previous thread example didn't show up like I had intended: Here a better example: Column A 100 Column B 1.5 Column C I need 100 - 1.5 (answer should be 2350)

My new job requires me to use access so I'm learning as I go. :confused: I have already used previous threads from this forum to answer another problem I encountered. Thanks for providing this forum to the public! I am attemping to run a query that will subtract military time. (I am not...