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 derfloh 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. EarlStaley

    What Type of Table

    I use Database Desktop to create my tables. I have the option of creating the following types of tables: Paradox (various versions) dBase (various versions) FOXPRO INTRBASE MSACCESS When I use a SQL CREATE TABLE statement, what type of table is created? Thank You... Earl Staley
  2. EarlStaley

    EXTRACT in ORDER BY

    JarlH, I had already tried your suggestion and that didn't work either. The only place an EXTRACT statement works in my implementation is in a WHERE clause. For example: "SELECT * FROM FSBC_Member WHERE EXTRACT(MONTH FROM BirthDate)=1 ORDER BY LastName, FirstName" That is the only place I...
  3. EarlStaley

    EXTRACT in ORDER BY

    I have a table for our membership with a Date field for birthdays. I am trying to get a list of the birthdays ordered by month and date. My first attempt to get the list used this SQL: "SELECT * FROM FSBC_Member WHERE BirthDate IS NOT NULL ORDER BY BirthDate,LastName,FirstName" This...

Part and Inventory Search

Back
Top