Search results for query: *

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...

=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...

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...