Search results

  1. J

    Query returning Dates outside input Dates

    Hey all, I'm trying to run a query (that uses a subquery)that counts a couple things between a date entered by the user at the time of the query. When I enter the dates, it returns results outside the dates I entered. For instance, I enter 7/31 (July 31) as a begin date and 8/6 as an end date...
  2. J

    Counting two fields from a query, using a query

    First off, I'm using 2 queries, LAME ASS (which stands for "Longterm Average MEdia ASSessment) and SUB LAME ASS. Here is the code for both: SUB LAME ASS: SELECT EXSUMs.[IPA/West], EXSUMs.LOO.Value, EXSUMs.Tone, EXSUMs.[EXSUM Date], EXSUMs.[EXSUM Body] FROM EXSUMs WHERE EXSUMs.[IPA/West] =...
  3. J

    Finding users in a table who are close to the age 18

    Hey all, just joined up and I'm excited to see if I can get my problem resolved. Now, I am pretty new to databases and SQL, so you might have to be pretty basic with me. I'm trying to query a table with a bunch of birthdates in it, and I'm trying to find records that are 3 months away from...
  4. J

    Here I am

    I'm relatively new to using databases\SQL and I have a side project which I will be asking questions about. It looks like this forum is used enough, so I'm excited to be a part of it. I work in the Atlanta, Georgia area and I'm kinda new to it as well. Looking forward to learning... Joseph
Back
Top Bottom