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 Chriss 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: *

  • Users: jerrylj
  • Content: Threads
  • Order by date
  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 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...
  3. 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