Search results

Here is my Db Here you can see the table i am using. It is fairly long winded due to all the data inputs. However i want a query that will look into the delivery status column and give me 2 results in one query, so I can see in one place how many pending ILT days and how many consumed ILT...

Hi there. Can anyone help me with a question about queries. I have a table that records all sessions, those sessions would either be delivered or Pending, and would be attached to region Is there a way of having one query tell me how many of each there are in each region? Jay

Hi All, I am a complete novice with Access. I have set up a sample database, and i need some help with my forms. What i would like is a form that has search options on it, and the results are shown in a subform on the form. I have tried this and i keep getting lost. I have zipped up my...

I am a complete novice to all this, could you help me understand how I use the query to define criteria and then how the filters work

Hi all, Have now zipped up my DB, and wanted some help with search form, what is the best way to get this working?

I really need the search to work through the criteria above. I am a novice with access, so forgive if the Filters option seems long winded

Yes that is correct, that is what i am trying to do

I am currently creating a database and some help with the search function which i am trying to create using forms controls and subforms. I have several search fields:- Course Instructor Vendor Publish Licensed Completed TTT I have a button which I have created, which when pressed will search...