Search results

  1. G

    Specific day query

    Hi, i have a large table with millions of entries. I want to run a query to return all entries that are on a Saturday. The date stored in the table though is just typical date format eg 15/11/2015. Any help would be appreciated Regards Luke
  2. G

    Importing Excel Files

    Hi. Access Version 2010 Excel Version 2010 I have 200 excel files in folder C:\Users\Lburch\Documents\Historic Data\Tedan Data in Excel Worksheets - Copy\AAA - Copy The files only have one worksheet and the column format are the same. Worsheet name is different for every file though. Headings...
  3. G

    date wildcards in DCount

    hi, i need to count how many entries are before a date in a list box. the issue is the date of the record is used to give it a primary key eg lathl15/06/11r1. can i use dcount for this.
  4. G

    run a sum query on an id in a combobox

    Hi i have an athlete db i have a form with a combo box i want a cell to tell me how many races an athlete has had once i pick the athlete in the combo box there is also a cell with the date in it i want the "how many races cell" to only show the number of races the athlete competed in before the...
  5. G

    Subform to show records of Listbox

    Hi, the form is a main form to the orderdetails table. on the form there are two listboxes one is attached to the CustomerTable one is for the StoreTable then the other fields are what was ordered how many etc that fill the OrderdetailsTable. When i pick the customer in the listbox i want all...
  6. G

    combo box linked to sub form

    Hi, i have a combo box on a form, i want a subform to show all the athletes races when i pick the athlete from th combo box. in properties of the subform it only lets me link to tables or queries.. TY LB
  7. G

    data entry 3tables 1 form

    hi, i want to create a form where i can enter in 1- an athletes name (then his details come up eg dob) then 2- enter in the race he ran in (if its a new race then plots in table if its a race entered already then the other details come up eg distance date) then 3) enter in the athletes...
  8. G

    one form for multiple data entry

    Hi, We need a db for our athletics club. i have split the tables into three categories 1) Athlete Table -Athlete ID (primary key) -Name -Age -Sex 2) Race Table -Race ID (primary key) -Date -Age Division -Distance -No. of entrants -Track 3) Race Results Table -Race result ID (primary key)...
Back
Top Bottom