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!

  • Congratulations strongm 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. notstock78

    finding the last date

    I am very close to getting what I want. I have this so far but I still want one more field in this quiery. I am still trying to put the field POSHIST.TMWIN_LOC. When I try to put more that 2 fields I get an error, what am I doing wrong? Here is what I've got so far. SELECT...
  2. notstock78

    finding the last date

    In my database I have a new entry entered automatically every so often. The entry does not have a specific time that it enters but the time it is entered is kept track of. I am trying to pull the most recent entry to the database using MSSQL but I cannot get it correct. I have pulled all the...
  3. notstock78

    last date

    OK, this table keeps track of different positions of our vehicles with satalite positioning. We have many different vehicles with each there own ID. There is another column with the date and time when the truck was pinged. This is what I have so far. select POSHIST.processed...
  4. notstock78

    last date

    In my database I have a new entry entered automatically every so often. The entry does not have a specific time that it enters but the time it is entered is kept track of. I am trying to pull the most recent entry to the database using MSSQL but I cannot get it correct. I have pulled all the...
  5. notstock78

    querying a date range in MS SQL

    Thank you, it works great. I am just starting learn SQL and I have been struggling with some of the syntax.
  6. notstock78

    querying a date range in MS SQL

    I am trying to find the proper syntax for querying every thing from a specific date range using MS SQL. The table is SE_DATA and the field is SEDATE.
  7. notstock78

    Custom paper sizes

    I am wondering if anyone can tell me where I would have to go to set up a custom papersize for a printer. I am using an Epson FX980 Dot matrix printer.
  8. notstock78

    Linking 2 Tables

    Thank you both I finaly got the tables to link the way I wanted. Jason
  9. notstock78

    Linking 2 Tables

    I am new at the Crystal Reports program and I am looking for some help on linking 2 tables. Every time I try to put more that one table in my report and try to preview the report no data shows up. I am wondering what I am doing wrong. I am adding another table to report and finding the table...

Part and Inventory Search

Back
Top