Search results

  1. T

    Using SQL in Access

    would you be able to give me any hints on how to do this, i tried the help, but the directions didn't make any sense to me
  2. T

    Using SQL in Access

    only problem with that is I have this Huge SQL query i created, how can i incorportate the paramter queries into that?
  3. T

    Using SQL in Access

    Hi, im creating a query in Access using SQL. what i want is to have variables, Like WHERE e.date BETWEEN @from and @thru It keeps telling me to declare the variable. can someone help me with the syntax on that please? Thanks Tim
  4. T

    Recode Table

    I'll have to keep that in mind, im more familiar with sql than i am access.
  5. T

    Recode Table

    an sql function, MONTH(date) returns the number for the month, and DATENAME(Month,date) returns the actual month name
  6. T

    Recode Table

    I just wanted to thank everyone for their help, After messing with the sql query for a while, i was able to get this to work for me. DATENAME(Month,e.er_1_date)
  7. T

    Recode Table

    I tried the MonthName(Month(datevalue)) But it bounces back an error saying "MonthName" is and Invalid Function
  8. T

    Recode Table

    Hi, I have a report that runs off an sql query (ODBC)... Im using the Function MONTH(FIELD) and it returns the Number of the month. How can i get this to show the work "January" instead of the number 1?? any suggestions would really help me out. Thanks :confused:
Back
Top Bottom