Search results

Im using SSRS 2005, and i have a table thats getting me my correct data. I have this in my one of my fields: =IIF(Fields!ReceiptQuantity.Value < AVG(Fields!ReceiptQuantity.Value) -14,Fields!ReceiptQuantity.Value,"") and in my details row in the visibiltiy i have this...

I am having trouble trying to get the most recent record. heres my query i get no results on this query. Basically what i want is if CMTCH has 4 records over 1 year. I want the most recent record. Example 10-1-12 8-1-12 2-15-12 5-25-12 I would want the records with the 10-1-12 date...

I want to be able to have a query automattically get the previous days data. i dont want to have the user enter any dates. heres my query: SELECT*--,MIN(formatdate) FROM bk_vAPTData Where formatdate >=dateadd("D",-1,getdate()) this gives me data for both 9-19-12 and 9-20-12 how can i just get...

Hello i have an excell sheet where the user enters in an 'x' in a cell and at the bottom of hte sheet it counts up the 'x' entered. here is my formula. =COUNTIF(F6:F74,"x") my question is, how would i do it if the user wanted to enter multipe 'x' into the cell and still count multiple 'x'...

I need to be able to query results from my table from yesterday at 7:01AM through today at 7:00AM. basically a full says worth of data. im not having any luck doing that. Any help would be great

I have a table that has a field called jobcode In this field it could have the same job code for example MKRLF. There could be mulitple records in this table for MKRLF. THis table also has a field called EFFDate, and what i want to do is always get the jobcode field that is the most recent...

Heres my scenario: i have a textbox with a point value for example is 225: I have a table that looks like the table below. What i want to have is to beable to look at the textbox that has 225 value in it and look at the range in the table below and have the 1st column values 1-10 to show up in a...

I have a user who has Windows 7, and used Word 2010. When she types an outline or uses the bullets and numbering feature, Word wont auto inddent for her. any help would be great. Thanks

Below is my query. We did a recent upgraded from SQL 05 to 08 and before this query would run in about 7-8 seconds on sql 2005, now in 2008 it takes well over 3 minutes to complete. any ideas why or what i can do? select receiptdate, lotnumber, receiptquantity, palletcode...

I have a field in my query that are like this 1 2 3 4 5 6 7 8 9 10 11 ect, but i want to know if there is away to make a field 2 digits so that my sigle digits will be 01,02,03, ect and then 10 11, 12 will stay the same?

I have a field called productiondate and the data looks like this 2-1-2012 or 12-25-2011 and its a nvarchar(50) value type. i want to use substring and charindex to get the day month and year into seperate fields of day month year so far i can do this below and it gets me the month, but i...

Im doing a simple form of 21 fields that rights to a sql table. my issue is i cant get it to work unless i have all variables as strings and strings fields in my tables. here is my code and if i try to put in a field as integer or date it errors out. Im using VS 2008 my variables Dim...

I have a field in a sql table called prodate but the field is a nvarchavr(max). data in this field comes in and looks like this 10/12/2011 or 2/15/2012, ect. how can i convert that to a datefield? i have tried cast(proddate, as datetime) i have tried using convert and nothing seems to work...

I have a query and im using between [Start} and [end] for my criteria giving the user a parameter to enter the dates they choose. im using a field called datesubmitted and if anything is submitted on 1st of month or last day of month it wont pull into query. so if i put 4-1-11 and 4-30-11 as...

I have the following statment to determine age of employees, but when i run the query i just get data like 60,50,44, but i want it to be like 66.55,50.59,44.16 depending on how close they are to their birthday. (datediff(d,emp.brthdate,getdate())/365) as age,

I want to find out a week number in a month in a query. for example this gives me the week number in a year datepart(wk,p1labdate) as week, but i would want to know somethign similar for a month for example for may 2011 and june 11. 5/1/11 would be week 1 5/8/11 would be week 2 5/15/11...

I posted this in the Macro Board and havent had any luck. heres my issue: I have a spreadsheet located on our network called dps2006.xls. This sheet is password protected. I want to know how i can import data from a tab called cream summary. i havent had any luck doing it. i can get non...

I have a spreadsheet located on our network called dps2006.xls. This sheet is password protected. I want to know how i can import data from a tab called cream summary. i havent had any luck doing it. i can get non password protected to work fine.

I have a scatter chart that is working the way i want, but when i want to add an average line to the chart, it runs, but my data changes. any ideas how i can do this? on my data tab on chart properties, i have an AVERAGE in the Values section. On the Y: axis expression i have...

I was wondering if anyone had any good ideas how to do this? I would want to use a macro in my access DB to get some data from a excel file that is password protected. Thanks