Search results for query: *

Hi, We are currently linking an MS Access 2003 front end database to an SQL server 2005 backend. When using SQL Server security and creating a dummy login on the SQL Server for all users that use the front end system to connect to the backend db, I'm getting a login box in the Access database...

Hey all, Is there an easy way to generate a report listing all my database tables, fields, data types, and the stored table/field descriptions alike the metadata reporting features in MS Access? I know I can generate the diagrams with this information, but they can get a bit hairy to look at...

Hello, I have an issue with my Access front end databases. A little background. Workgroup security has been implemented. The front end client is an Access 2003 application that sits on the users machine. The user runs a batch file on their desktop to check for updates to the front end and then...

Hi, We are in the process of trying to set up a transaction log shipping operation and are currently having issues with the copy job. The primary server backup job runs fine and then the copy job which runs from the secondary(copy) server is not able to copy the backup file from the backup...

We have a test server that I would like to use as both a "mirror" for our live databases and at the same time on this test machine, I would like to have an instance that would be used specifically for testing of new code. Am I able to do this and how does one go about installing a separate...

I'm trying to display in a field the previous month. Since it's currently May, I want the field to display April. I can get the field to say '4' but can't figure out how to get the month as a char. Using Datepart DatePart(Month, Getdate()) - 1 <--Gives me '4' Using Month Month(Getdate()) - 1...

Is there a way to format a floating integer to display as a percentage inside of a query? I have the number stored in the table as 0.75. However, I would like to display it inside the query as 75.00%. Is there any way to do this besides converting to decimal(18,2) and multiplying by 100?

Hello, I have a field in a query that I want to either show a dashed value '---' or a date. So I use this: CASE WHEN [RegStatus] = 4 THEN '---' ELSE [Step7Date] END AS Step7 Problem is, it tells me "Conversion of the char data type to date time has resulted in an out of range value". If I...

Is there a way to do the following in excel through a formula? For each value in Column A, I would like to find the maximum value in Column B. So for example: A B Monday 10 Tuesday 15 Monday 20 Wednesday 5 Monday 15 The formula would return...

Is it possible to alter a view within a stored procedure?

I'm stuck. I had a function that I was using in VBA in Microsoft Access to determine a date and take into account holidays and weekends. Basically I need to add one day to a date, but if the date falls on a Friday, it needs to give me Monday's date instead of Saturday. As well, I have a table...

Is there an easy way to web publish excel reports containing (dynamic)pivot tables and their graphs? My current excel report is 130mg and I need to find a better way to present it to people. I'm currently emailing the 130mg file and this creates a bit of a problem for some users. Any advice...

If I have a range of numbers such as follows: 5239 2181 989 568 420 203 161 44 I want my graph to show the first 1000 axis ticks as 0, 100, 200, 300, etc. Then above 1000 I would like the axis ticks to be 1000, 2000, 3000, etc. Is there any way to set this up? Any advice is appreciated.

If I have an integer being passed in, say 2 for example, and I want to store this in part of a string as 002, is there a way to set this up during my stored procedure using the CAST function? Any ideas are appreciated.

I'm completely at a loss as to what is happening in my views. I have a subquery that has values 255.42 and 319.275 for one field and one employee in my query. If I run a SUM on top of this query on this field, for some reason it gives me a bunch of extra decimal points. The answer should be...

Is there anyway to set DateFirst in a view? I am doing a series of invoicing views in which I sum up weekly employee info and then link it back in with it's daily data. There are about 5-6 query levels that I use to do this to satisfy different business rules for the invoicing. Problem is they...

Hello, I have a field that stores StartTime and a field that stores EndTime in my database. I want to get the total hours so I'm using DateDiff(hour, starttime, endtime) but that's giving me a rounded number of hours. I want the hour and minutes in decimal but rounding up every 15 minutes...

My dates are stored as smalldatetime in my database. Dates are entered along with the time an item is expected to start on, i.e. '9/15/2006 8:00:00 AM' If I want to strip away the time so that I can do a group by and get a count of how many entries I have on each day, how do I do this? I tried...

Hi, I'm trying to create a function that raises a number to a power of 2. So like 6 squared is 36. However for some reason when I run it it gives me 4 as an answer. This is the syntax I have for the actual computation SET @Result = (@Variable ^ 2) Even when I remove @Variable and replace it...

We were given a .BAK database file from our client that I believe is in SQL Server 2000. Problem is we are running SQL Server 2005. I've read where I'm supposed to create the database and then restore using the .BAK file to get it up and running, but I'm getting an error which I think is due to...