Search results

Hi Nigel, That seems to work with both tests. I'm thrilled. Thank you!

Hi Nigel, I'm not sure how this helps to find the solution? The formula doesn't work with the signs in either direction, from what I can see and from where others have seen, as well. If you have a suggestion for a solution that works for the entire range as posted before, please share it...

Hi Nigel, The solution you have suggested didn't work before so that John, above, suggested switching the signs around. This actually did resolve the problem as presented but didn't meet the entire range of needs for the search query. Maybe some combination of the two will resolve the...

Hello Mr. Booty, Thank you for your efforts! You just knocked my socks off. Yes, this does work for the examples given, however, when tested further yielded the following problem: When I did a search for the years 1929-1935, it returned zero results when the following records should have...

Since I've not received replies that are immediately applicable to my project, can you recommend other forums?

I've been looking through the SQL Cookbook by Anthony Molinaro and wonder if the following is relevant. It uses a self-join. If so, how can I apply it to my project? Identifying Overlapping date Ranges: Select * from emp_project a, emp_project b where a.empno = b.empno and b.proj_start >=...

Yes, I need to return the actual roll of microfilm that contains the newspapers between the dates requested in the search and I need to be able to search by year only. Maybe someone else has an idea of how to do it? VBA is a bit beyond my skill level right now and I'm not sure I have time to...

Here is the problem: Each start and end date on the Serials table represents the range of newspapers included on a single roll of microfilm. One of the problems that arose with testing was that a search of Start year 1914 and End year 1915 (we’d like to be able to search the DB by year and also...

Thank you for your reply. As I said above. I feel that I need to share the actual DB in order to receive help with this question and am unable to upload it. If you are willing to help via email, please let me know. Thanks again!

Hello, I am using Access 2007 for a database. The query that I'm using works in MS SQL Server but I only have Access 2007 to use for this project. There is a glitch in Access 2007 that causes it fail to return all the necessary records. Is there someone who can help with this problem? I am...

I was referred by bremus although the form submitted when I pushed enter to get out of the ant-bot box so I wasn't able to say so there. I am currently an extern and student at Kaplan University Online. I'm so glad to be in touch with seasoned pro's. I'll be especially interested to learn to...