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

Great thank you Pat, one last thing a prompt is coming up ...."Enter Parameter Value" ....this shouldnt happen should it?

Yes, it is Text, "error message in string in query expression": Where [CPC Weekly Data].[Region] = ' " & Forms!CPCREMilestoneFormReport!CboRegion & "'"

This helps: Im getting Error on this in the Record Source query...is there something wrong with the syntax? SELECT [CPC Weekly Data].Region FROM [CPC Weekly Data] Where [CPC Weekly Data].Region = ' " & Forms!CPCREMilestoneFormReport!CboRegion & "'" GROUP BY [CPC Weekly Data].Region ORDER...

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

Yes, this seems to work but the output is ommiting the N/A's meainging its only showing Yes and No population not the N/A population. How do I keep the N/A polustion displayed? Thank you very much.

Well based on my perception, what you are trying to do is: * Check if [CPC_Old].[Project released for planning Actual] AND [CPC_New].[Project released for planning Actual] are NULL, if so then enter the value N/A * If either of the two fields are not empty then you have to put Yes or No. Is...

In english: Im comparing Dates from old to new table with alike fields....Im creating a Flag in the output to give me a Yes if the dates have changed and a No if they are the same...now if both fields are empty then I need an N/A . Ive already got a Yes and No in the output ...I simply need a...

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

This closer ? Its running but not giving me N/A in the output just yes for the cells that are empty... IIf([CPC_Old].[Project released for planning Actual]=[CPC_New].[Project released for planning Actual],"No","Yes") & IIf(IsNull([CPC_Old].[Project released for planning Actual]) &...

pr2-eugin, So my understading is that I can place these two toghter due to boolean and string....are you able to help? IIf([CPC_Old].[Project released for planning Actual]=[CPC_New].[Project released for planning Actual],"No","Yes") And IIf(IsNull([CPC_Old].[Project released for planning...

Ok this makes more sense: Is it safe to use this in the Criteria: IIf([CPC_Old].[Project released for planning Actual]=[CPC_New].[Project released for planning Actual],"No","Yes") And IIf(IsNull([CPC_Old].[Project released for planning Actual]) And IsNull([CPC_New].[Project released for...

Input values are comapring two tables with exact feilds but at different time frames. Im trying to tell the query to give me a Yes if the two variables are differrent dates, No if they are the same and, N/A if both fields are blank. The third part I'm having trouble writing the logic. So this...

Thank you for the quick response, Yes I would like to place an N/A in this criteria.. where both the Old and the New tables have empty cells or (in this example don't have a date) and (basesd on these condistions) give me an N/A.

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