Search results

Yep it is right...the numbers I was checking it against at an extra month added that I didnt catch. Thanks though!

Ok...that works...however I am getting the wrong amount of days. When I do the following equation I get 243 days when I should be getting closer to 270. Any clue as to why? =DateDiff("d",(DateSerial(Year(Date()),Month(Date()),1)),"9/1/2009")

So I have two dates, [Start Date] and [End Date]. These are in mm/dd/yyyy format. I would like to subtract them in order to give me the amount of days in between the two dates. However the kicker is that I need to convert each of the days to be the first of the month before subtracting so that I...

I apoogize in advance for the messyness of this expression but here it goes: =IIf(Format([Delivery To],”yyyy mm”)=Format([Month2],”yyyy mm”),([NoCars]-[Past]-[Month1Eq]),IIf((IIf(IsError(IIf((Format([Month2],”yyyy mm”)>=Format(Now(),”yyyy mm”)) And...

I have some long expressions that I use in reports. Is it possible to assign the expressions to some sort of variable so when I have to use that expression in another expression it doesnt get too confusing. I tried naming it through properties but that didnt work. Example: Expression 1 is...

You were correct pbaldy. I changed it and it worked fine. Thanks!

Sorry bout the confusion Bob...but the error was occuring specifically on this part: (AND(([Month1]>=Now()),IIF(SUM([Past])-[Balance]<0,IIF([Month1]>=[Delivery From],[Balance]/[PartitionEq]))) Good observation pbaldy...I'mma try out what you said and report back.

I have the following code in the expression builder: =IIF(ISERROR(IIF(AND(([Month1]>=Now()),IIF(SUM([Past])-[Balance]<0,IIF([Month1]>=[Delivery From],[Balance]/[PartitionEq]))),[Balance]/[PartitionEq],0)),0,IIF(AND(([Month1]>=Now()),IIF(SUM([Past])-[Balance]<0,IIF([Month1]>=[Delivery...

I apologize for my ignorance but im not sure what you mean exactly. I want it to look like: Bus ---------------- ---------------- ---------------- ---------------- ---------------- Train ---------------- ---------------- ---------------- ---------------- However what I am getting...

So I have two types of transportation in a report, Bus and Train. I want to have all of my bus information together, then a total and my Train information, then a total and finally a grand total. However no matter how I try grouping I always end up with most of the buses together, then the...

Thanks!!! Really quick...what exactly does that statement do?

I have a simple expression in a report I created: = [query1] - [query2]. The results being returned in the queries are based off of the COUNT function. When a number is returned for both queries then it works fine. The problem is whenever query 1 or 2 do not return a number then the report...

I thought that could be the case too...the same thing happens when I enclose each with Nz(). Maybe its something else?

I have 3 consecutive update statements that have the following in each respective WHERE section: (MkFrmFunc_Table.Function1 <> "")And(MkFrmFunc_Table.Function2 <> "") (MkFrmFunc_Table.Function1 = "")And(MkFrmFunc_Table.Function2 <> "") (MkFrmFunc_Table.Function1 <>...

Me.SubRegion_Combo.Column(0,i) works actually. I should have told you before that this is taking place inside of a a for loop. SubRegion is the only variable changing inside the loop. That is why I wanted to get the correct volume for each subregion. Its something else, most likely the syntax.

K...I put the break in and it stopped on the following line: CurrentDb.Execute MySQL, dbFailOnError dbFailOnError is equal to 128. I figured that the error is with my &'s or "'s as you've pointed out. I also will reorganize my code so that it's easier on the eyes :)

MySQL = "UPDATE MkFrmFunc_Table SET MkFrmFunc_Table.Percentage = '" & Me.Percentage_Text1 & "', MkFrmFunc_Table.Volume = " & (MSize * Me.Percentage_Text1) & ", MkFrmFunc_Table.Ingredient = '" & Ingredient_Combo1 & "', WHERE ((MkFrmFunc_Table.Region = '" & Me.Region_Combo.Column(1) & "') And...

Alright RG...how much is your consultant fee? lol... IT WORKED THANKS!!!!!!

Yeah I dont know what happened to them sending emails...I just sit and click refresh lol. The RowSource is posted in the post #4 and its a Table/Query.

No it is just North America...we should walk through and create a new record for each SubRegion in North America only. There are SubRegions for Africa, Asia and so on...therefore we only do "All" for the selected Region. In the example its North America. When we choose North America in the combo...