Search results

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

Wow, I just figured that it is as easy as selecting the LOO field, then the Tone field, then just one COUNT operation, then group it by LOO, then Tone. Simple.

Oh, and I believe that in order to do my Total1-3, it may be possible just to do a totals row that Access 2007 uses.

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] =...

I knew it had to be simple, I just knew it!

Wait, I just typed into my query what I typed up there and it worked....... I swear it didn't before!!!! AhHHH! That's relatively frustrating....

So something like: select [fields from the table] from [table name] where datediff('m', table.[date of birth], Now()) > 212 Is that the correct syntax?

I'm clueless on the datediff function really. I know the parameters I have to input, but I don't know how to use it.

Another question I should ask is how do I store the returned value so I can compare it to 212 months?

Hey Guys, thanks for the replies. I've been away from the client that I've been doing this work for, so I haven't been on here in a while. What I need is for the query to compare the current date with the birthdate of my records in my table. If the number of months is greater than 212 months...

This would indeed start up a fire storm. To Vassago I would say "What was the national debt before Obama? What is it even now that he is still in office after only two years?" Especially with his massive Healthcare plan that will make healthcare affordable for none. Obama also issued bailouts...

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

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