Search results

  1. V

    Null Values

    Thank you Thank you for, It's working Viral
  2. 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...
  3. V

    Matching Data Help!!!!

    No data Sorry it doesn't work When I add left function part it doesn't show any data. Final query is this: SELECT NewMyEstartChild.yordob, NewMyEstartChild.firstname, NewMyEstartChild.surname, NewMyEstartChild.postcode FROM NewMyEstartChild INNER JOIN For2003 ON (NewMyEstartChild.Firstname...
  4. 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 =...
  5. V

    Common Data

    Thank you It's working now, thank you for your reply Viral
  6. 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...
  7. V

    beginner help- Open Form

    thank you it's working
  8. 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
  9. V

    date query

    Thank you It is working
  10. 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
  11. V

    Simpale Date Query

    thank you thank you it is working now.. i tried min before but it wasn't working viral
  12. 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...
  13. V

    Simple question

    Thank you thank you for your advise Pat Hartman. it's working now. actually it's not my database. Company I work for has already set up this database. Viral
  14. V

    Simple question

    No Luck Sorry Still no luck, It's coming with only one field and I have more then 30 fields on my database. Any other way I can do it ? Viral
  15. 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...
  16. 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