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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jerrylj

    recover a deleted accedd database

    We just had a access database deletd by error and descovered that it was not backed up. Does anyone have any ideas on how to retrive it. I was deleted over the network from a remote pc so it isn't in any recycle bin. Thanks Jerryl
  2. jerrylj

    Trying to join a table in access to a crystal SQL command

    I am pulling from Sybase using ODBC.
  3. jerrylj

    Trying to join a table in access to a crystal SQL command

    sorry I forgot to say I am using Crystal 10.
  4. jerrylj

    Trying to join a table in access to a crystal SQL command

    I am trying to join an access table with the key field being a currency field to an SQL command with the key field being in currency also. I am using ODBC to bridge the two. The error I get is that the "DATA TYPES ARE NOT COMPATIBLE" I do a browse field on the access field ond it says number...
  5. jerrylj

    using DATEPART function in a SQL where statement

    Thanks it looks like that will work. One of the problems with being self tought is not knowing all of the functions.
  6. jerrylj

    using DATEPART function in a SQL where statement

    I am using the following in a where statement for a sub-select: glpastyr.calmonth = DATEPART(month,getdate())-3 this will work fine if the current date is greater than march 31 of any given year. If it is less than 3/31/xxxx then an error is returned because the month becomes a negative...

Part and Inventory Search

Back
Top