Search results

Im using Tsl(MSSQL2005), how do i do it without using a function?

Ok below gives me what i need, but how could i take the below statement and convert that to a date? Cast(p_month as varchar) + cast(p_day as varchar) + cast(p_year as varchar) as date

I have 3 fields(see below) one for day,month, and year. p_day p_month p_year however i try to concatenate them its just adding them up. so with data like this 1 26 2011 i would want to see it like this 1262011. what its doing for me is giving me a number of 2038(adding them) thanks.

Not sure what the deal was, but i deleted her ODBC and recreated it and it seemed to work...

Yes i used the one in the WOW64

i am getting a ODBC -- Call failed error [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect Syntax near 'dbo' (#102) when running reports. This is an access 07 application created on a windows 7 64 bit PC. I have 2 linked tables to a Microsft Dynamics views i created, i am linking them...

That worked, thanks.

heres my formula now. =100000 - Nz(Sum([act_AnnualizedPayChange]), 0) + IIF([SUBrpt_ProductionQuits].[Report].[HasData], Nz([Reports]![SUBrpt_ProductionQuits]![textbox53], 0), 0) i got the report to run but i get #NAME?

No im starting with a hardcoded value of 100000 then subtracting the total from the main report and then subtracting the total from the subreport. what are the NZ? my formual below still does not work, any help would be great? =100000 - Nz(Sum([act_AnnualizedPayChange]), 0) -...

=100000-Sum([act_AnnualizedPayChange])-IIF([SUBrpt_ProductionQuits].[Report].[HasData],[act_AnnualizedPayChange],0) this is what i have, and im not getting it to come out. i get errors saying invalid synntax.

here is my formula, so how would i incorporate the formula into mine... =100000-Sum([act_AnnualizedPayChange])-[SUBrpt_ProductionQuits].[Report].[act_AnnualizedPayChange] 100000 is my hardcoded number

I have a report that have a column and totals up that column, also i have a subreport on this report that has a column and totals up that column. Then at the top of my report I am adding these to columns up, and subtracting them from a hardcoded number. My issue is when the subreport doesnt...

yes box pops up, i enter in a valid date, and it executes with no results.

Below is the query. I should get 1 result thats what i get when i hard code a date in. when i put this <=[Please Enter a Date] i get no results, hardcoded date and the date i put in the input box are the same. SELECT MarketPrices.MarketDate, MarketPrices.BlockPrice...

Sorry that i missed that key piece of info. i used this: <=[Please Enter a Date] and i still get no results.

When im using is <=[Date] I want that to pop up a input box so that i can type in a date. thats the reason for the brackets, it can really be anything it could be <=[MinnesotaVikings] but what im trying to do is use this field: PricingStart: DateAdd("d",-3,[MarketPrices].[MarketDate]) and in...

Well Im working on an access qurey. And im trying to figure out how to get my results to work. MY criteria is wrong, as you can see from my original post and thats what im trying to get help on. I never said anything about SQL, and im on an Access forum in the qurey section.

This is in access. so in my criteria i should have <= Date()?

I have a qurey that has the field name like this: PricingStart: DateAdd("d",-3,[MarketPrices].[MarketDate]) And in my criteria i want to do <=[Date] but that dont work. When its run nothing comes out in my results. When i hard code the criteria with a date it works fine. Any help would be great.

Never Mind I found my answer. Sorry for any Inconvenience