Search results

Here is the If statement flag : CPC and MM Flag: IIf(Date()-[CPC Milestone 14+].[CPC and MM approves floorplan Target]-[CPC Milestone 14+].[CPC and MM approves floorplan Actual]>"14","14+") The CPC and MM approves Target/Actual fields are in Date/Time format I would like to calculate a...

I have a combo Box in a split form and would like the form to filter only on specific critera. For Example, there is one to many relationship to "Region" in my data and would only like to show all records in the "West" region. Currently when I use the combo box on a specific region it just moves...

I created a Combo Box (in the form header) for Region (Central, East, West). I dropped the the Data table into the Detail section of the form. (Contains feild called Region) I would like to be able to drop down say on the Central Region and see all rows for Cental...in this example it it 250...

Sorry of this is elementary to everyone but I can't seem to get this statement to generate N/A if both fields from the tables are Null. Here is the Criteria I wrote: IIf(IsNull([CPC_Old].[Project released for planning Actual]) & IsNull([CPC_New].[Project released for planning...

Hello, I'm new user in Access 2007. I attempting to build nested IIf Statements mostly on Date/Time Fields. This example is a new field or (flag comapring two data sets with same variables) I'm getting error message: "Data type Mismatch in criteria expression". Im not sure what I need to update...