Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by RevelationUK

  1. RevelationUK

    problem with wildcards /searching

    sorry, I found the problem. The query should be: WHERE tblCustomers!Surname LIKE Forms!frmFindCustomer!txtSurnameNOT WHERE Forms!frmFindCustomer!txtSurname Like tblCustomers!Surname odd :(
  2. RevelationUK

    problem with wildcards /searching

    The following query: SELECT tblCustomers.* FROM tblCustomers WHERE Forms!frmFindCustomer!txtSurname Like tblCustomers!Surname And Forms!frmFindCustomer!txtAddrLn1 Like tblCustomers!AddrLn1 And Forms!frmFindCustomer!txtPostCode Like tblCustomers!PostCode And Forms!frmFindCustomer!cboStates Like...
  3. RevelationUK

    Date_Add

    Im trying to implement the Date_Add function, but im having some problem. SELECT tblCustomers.* FROM tblCustomers WHERE (((tblCustomers.State='No Letters Sent') And (tblCustomers.DateEntered<=Date_Add(Date(),INTERVAL 1 MONTH)) Gives me an error, how do i correct this? I know its a silly syntax...
  4. RevelationUK

    Adding 1 month to a date?

    as in, if i have CurrentDate = 1st Feb and I add "1 month" it will return: 1st March
  5. RevelationUK

    Adding 1 month to a date?

    In Sql, how do I add exactly 1 month to a date in the format mm/dd/yyyy ?
  6. RevelationUK

    Using convert and getdate functions

    Im trying to make a query , heres what I have so far: (the Date in my access database is in the format "dd/mm/yyyy") SELECT * FROM tblCustomers WHERE (tblCustomers.State='No Letters Sent') And (tblCustomers.DateEntered='29/06/2005'); however I get type mis match, now I believe I have to use...
See more

Part and Inventory Search

Back
Top