Search results

  1. S

    Query to look day / month (and not year) then produce an average

    Apologies if this isn't explained particularly well. I have a table containing dates in column A and a number in column B. What I would like to do is average the numbers in column B based on the day and month in column A and for it to show the latest full date range. So in the example below...
  2. S

    Unmatched in the last 30 days

    Hi all, there may be a simple solution to this, but it isn't leaping out at me this morning. Two tables, customers and orders and I want to know who hasn't placed an order in the last 30 days.
  3. S

    Advice on forms

    Hi All, Still fairly new to Access but slowly learning. I have a form with a built in search function and would like to place this in a navigation form. The search works ok on the form, but when I add it to the navigation form it doesn't. The search is done by a macro on a command button...
  4. S

    Display additional text box if "Other" is selected from a combo box

    Hi, I think maybe the thread title will explain most of what I want to do. When the text "OTHER" is selected from a combo box I would like an additional text box to appear which can be used. If any other selection is made from the combo box, I would like the additional text box to remain hidden.
  5. S

    Merging tables

    Hi Guys (and Gals), First post so please hang on in there with me as I'm not too familiar with access terminology but I'm leaning! So here is my problem. I have two tables which have data in them which is trawled from source which doesn't have any data manipulation tools in it. I want to be...
  6. S

    New starter

    Just nipped in to say hi! A newbie to this forum and access to be honest. I use it a bit a work but want to learn more.
Top Bottom