Search results for query: *

That is what I did and it shows that typically the 1st indexed is RED - and it states Many places that it is Typically assigned to the Primary Key from the database you are pulling it in from. I looked into the Access Tables and NONE of the Primary Keys Are red????- but Other Non Primary keys...

That seems odd that you have to do this - In Access if it is empty just what is there shows up - Any other way to do this to handle ANY of the fields being empty????? if not can you show the Multiple else if code?? thanks, bkel

I am trying to understand the Links Tab in the database expert- where it shows the Index colors. I have read that mostly primary keys are Red - the 1st indexed. ALLL of my tables from Access Primary Keys - are showing ANY color Other than RED. but Red is assigned to NON primary keys. Please...

I created a concatenated field including city, state and zip - It looks great but when the city field is empty but data in the state and zip - the entire calculated field is blanks??? how do I get it to show the state and zip at least if there is one??? Region={city}&", "&{state}&" "&{zip}...

i have an expense table where 3 categories are General and 7 are specific- when the record in the table has one of the General Categories- depending on which of the 3 general categories it is - say Cat1, Cat2, Cat3 - ex. if Cat1 the expense amount needs to be mulitplied by a %allocation for the...

sorry - a little more - actually with the percent formatting the answer should be -100% but again getting a blank??

one more thing i noticed - if year 1 is say 10,000 and year2 is 0 the calc. is Year over year change (0-10000)/10000 so the answer should be -1%? but getting blank there are a few other situations where the answer should be -1% and getting a blank- that is the only place I have blanks if year 1...

Just wanted to note it is formatted as Percent with one decimal place - don't know if that has something to do with it? thanks, bkel

=IIf(Nz(Sum([2010]),0)=0,0,((Sum([ExpenseCrossTabForecastExpense.2011]))-Sum([2010]))/(Sum([2010]))) I am doing a calcualation ON the Report itself calcualting change year over year and adding this got rid of some of the blanks and put in 0s but some are still there?? when its (0-0)/0 or...

Alright - noticed something else when I added the tblXtabColumns table to the crosstab query my totals of the groups of Mega by category by reportcategory2 are less before I added that table??? seems like it does not account for all of the data?????? Please keep helping - and Thanks a ton!! bkel

Sorry one more thing I just notice with the crosstab query the way it is above - when I put in 2009 and 2010 I get ForecastExpense1 and ForecastExpense2 and same for planexpense When I do 2010 and 2011 I get ForecastExpense0 and ForecastExpense1 and same for planexpense for my columnHeading of...

Not sure if this matters but usually only 2 calendar years look at - Present year and previous year. thanks again!!!!!!! bkel

Did you create a two record table for the multivalue crosstab? This would have records with Forecast and Plan. YOUR ASSUMTPION ABOVE IS CORRECT. the crosstab looks good. Here is My Sql that seems good for the Crosstab query TRANSFORM...

sorry actually need Forecastexpense 2010(wrong-prev.post) and planexpense & forecastexpense 2011 sorry, bkel

Assuming on my problem where Month is below I would put Year([CalendarYear]) your Column Heading expression is Expr1:[FldName] & Month([OrderDate]) Need PlanExpense for prev year(2010 for now) and Plan Expense and Forecast Expense for 2011( next year dif) your Value expression is...

I have 2 crosstab queries Here is sql for 1 TRANSFORM Sum(qryExpenseHandleCategory.ForecastExpense) AS SumOfForecastExpense SELECT qryExpenseHandleCategory.Mega, qryExpenseHandleCategory.Category, qryExpenseHandleCategory.ReportCategory2 FROM qryExpenseHandleCategory GROUP BY...