Recent content by pdx_man

If you have no forms, then there would be no reason to "require" linked tables.

You must use a pass-through query to run TSQL statements directly on SQL Server.

Put a Breakpoint on the Docmd line. Go into the <b>Immediate</b> window <i> Ctrl G </i> and type in: ? strSQL Hit enter. That will return what is in the variable. Copy this to a query. Query Window <New> <OK> <Close> <First button on toolbar SQL> <Paste> <!> Debug that and correct your VBA...

Have you tried Ye Ole: Environ("Username") ??

Use this. Then it will work for any precision: Function CRound(MyVal As Double, Prec As Integer) As Double CRound = Int(MyVal * 10 ^ Prec + 0.5) / 10 ^ Prec End Function

I don't believe that would work if there were no results return from the nested select. It won't return a null value ... just no rows at all.

You'll have to check if there are any results first. Something like this: IF EXISTS(Select YourValue From YourTable) Select YourValue From YourTable ELSE SELECT 0

Sure thing. It is always nice to see that our efforts are appreciated.

OK, let's line things out here ... You are running SQL 2005 Reporting Services You have a MS Access database as the data source where the data is stored locally in the Access database. My guess is that you are trying to reference a query in that Access database which uses an Access function...

I'm guessing you are looking for the DateName function. SELECT DATENAME(MONTH, [Date Entered]) AS Month_Name

This is not a simple T-SQL problem, but rather a formatting issue. In Access, a quick fix would be: Format("01/2/1998","mm/dd/yyyy") A T-SQL fix would involve using the CONVERT function. Refer to BOL.

Well, I'm guessing you are doing this query in Access ... so there is no MONTHNAME function ... try: Format([Date Entered], "MMMM") If you are looking to do this in SQL, you will have to do a CASE statement for the month: CASE MONTH([Date Entered]) WHEN 1 THEN "January" WHEN 2 THEN "February" : :

If you don't have a scheduled Windows task, then how can you ensure the database is open and working on the first day of the month? Basically you need to ensure a form is open and have the timer event set to check if Day(Date()) = 1

Hey Wideawake ... are you asleep? Did this solve your issue?

Try MID(YourField,5)