Recent content by jfca283

Yes i did. I only posted it on xls because i thought it would be simpler to import. Sorry.

There is the data. The table is named like the excel file, C1_AS. Please, consider that sometimes the field Area has spaces at the beginning, so the match isn't exact. I really appreciate your time. I tried to do the same with DLookUp and it collapsed. Thanks again.

Yes. Date is a field which contains dates in the format dd/mm/yyyy.

I shows me this the final query: syntax error (missing operator) in query expression '[Area]='xxx' AND [date]<#01-05-2010#'. (i use access in spanish, so i translated the error message)

It didn't work.

This is how it worked. Thanks for your guide. Var: ([yyz]-DBúsq("[yyz]","C1_AS","cDbl([date])=" & CDoble(DateAdd("m","-1",[date])) & " AND [Area]=[Area]")

Hi I'm designing a query. It's very simple. I just need to compute something like: Var: TT[YYZ for this month]-TT[YYZ for last month] The table is called C1 and has the fields i'm interested YYZ: Location TT: number mxx: date So, i have for YYZ a list of places and for TT a list of values...

Sheet1 has the data i need to process. Sheet2 has what i would like to get. I just need to obtain the monthly increase for a variable, in this case, yyz. Again, it's just calculate the differences among each Area record ( A, B, C, D, ...) . Each record is asociated with a date, which is unique...

Hi I'm lost. That's the beginning. I need to compute the increase for the field Area the following: yyz(t)-yyz(t-12). T es month. The table has this structure Area yyz date Y Area represents different locations. Each area has only one record per month. Month is obviously the field...

Hi I'm new. I hope to learn a lot using this forum. Thanks.