Search results

  1. V

    Null Values

    Hello, I have two tables called table1 and table2 with following fields: Table1: Name NameId Table2: Name NameID Visits where name and nameid is same but visit can me 0 to 230. name in table2 is same as table2 but only showing visit 1 or higher. How can I make new table that can list all...
  2. V

    Matching Data Help!!!!

    Hello, I am using this query to get matching data: SELECT NewMyEstartChild.yordob, NewMyEstartChild.firstname, NewMyEstartChild.surname, NewMyEstartChild.postcode FROM NewMyEstartChild INNER JOIN For2003 ON (NewMyEstartChild.postcode = For2003.POSTCODE) AND (NewMyEstartChild.yordob =...
  3. V

    Common Data

    hello, I have 2 tables called Table1 ( has field called Mydata) and table2 (has Field called YourData). Mydata has followind data 1, 2, 3 and yourData has 2,3,4 2 and 3 are comman data. how can I write query or type of function I can use to bring comman data I have used Union table that...
  4. V

    beginner help- Open Form

    Hello, I have created swithboard form that has couple of buttons. i need that button to display other forms. i am really struglling with that. i have looked at northwind project where it uses =openforms command but it doesn't work for me. thank you
  5. V

    date query

    Hi, Need Help!!! How can i write query that can display Age from given date of birth. I need age on 4th april 05. DateOfBirth 01/04/2001 04/04/2002 10/03/1999 02/02/1995 05/06/2000 21/12/2000 10/03/1999 thank you
  6. V

    Simpale Date Query

    Hello, i am stuck with simple query. how can i find oldest horse out of these? HorseName DateOfBirth Billy 01/04/2001 Blackjack 21/12/2000 Diamond 10/03/1999 Domino 05/06/2000 Keepagoin 02/02/1995 Neddy 04/04/2002 Waylogo...
  7. V

    Simple question

    Displaying empty fields I have tables with empty field called FullName. How can I display list of all empty field and “No carer”. Sample database is shown below. familyid fullname joineddate 80 Sambi, bal 28/02/2003 81 03/10/2002 82 Cutler, Wate 15/09/2002 83 No...
  8. V

    Access Table, fileds and attributes's names

    hello, Recently I have started working for one of the company where I have to deal with one of the access file. this file has lots of tables containing many fields. My question is How can I get all the tables name, their fields and attributes in Microsoft Word file. I have tried opening...
Back
Top Bottom