Search results

Brian, Thank you for your understanding, it gives me another view of this forum. And another big appology for Julie for using her thread as a platform for philosophical thoughts. Eli

Hello Brian, With all the respect : Why do you think that giving the correct answer teaches nothing? From my experience in Excel I've found that going slowly step by step will make you an expert after a few thousands of these steps… Take for example my first question in this forum...

Thank you Trevor, I figured it out myself. Eli

Hi Try: Expr1: Date() - [InvoiceDate] Eli

OK i'll try my best.

impossible: I wrote the link as text without http //tinypic.com/r/2608lqs/5 Eli

I tried that but there is no way to attach files at all even zipped files! I cannot even quote your link: To be able to post links or images your post count must be 10 or greater. You currently have 7 posts. Please remove links from your message, then you will be able to submit your post.

Hi Trevor and thank you The forum does not allow to attache links until one have 10 threads. Tell me please If you need more details Eli

Hi friends, How can I show by query all the books that has not been borrowed by a chosen reader? My query setup is: Table 1 readers( name etc.) Table 2 books (name etc) Table 3 Table of borrowing dates linked by 1 to many link to tables 1 and 2 Sorry! I am not allowed to send images yet Thank...

I 've found now a better solution to my problem using the same query1, with no need to create another query: Expr1: Format([NextBirthDate],"dddd") Eli

Hi Plog, much thanks for your answers. But let me clear out something that bothers me: With all the respect: Do I feel some unpoliteness or even sarcasm in your answers? or maybe I'm mistaken. Any way as a regular user of MrExcel's forum, with about 2000 threads, I always had the feeling that...

I did what you suggested but yet I get the number of readers multiplied 7 times. What do I do wrong? As to your first question , do you suggest to use the formula? if this is the case then what should I do when the second table is not days but anything else like months or cities? All the best, Eli

Hi, I am a beginner and wish to solve the following without using VBA or WeekName function. Table 1: readers name, readers birthdate Table 2: index, day (1-Sunday, 2-Monday etc.) Query 1: readers name, readers birthdate, weekday of birthday (by WEEKDAY([birthdate]) Now what I need is somehow to...

Hi, I am Eli from Israel, manager of a labortory in a hospital. In my work I am using Excel to analyse large scales of data. Now I want to expand my abbilities by using Access as well. I hope that I would learn much from your experience. All the best, Eli