Search results

  1. E

    Query to show all books that wasn't borrowed by a reader

    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...
  2. E

    Name of weekday in a query

    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...
  3. E

    Shalom to all

    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
Back
Top Bottom