Recent content by LB79

Thats great! Thanks so much!

Sorry its not the actual column names I want to change. I need to reference the columns that are the result of the crosstab. In my crosstab I have 'Column Heading' = 'Mth'. When the query runs it displays 2 Mth colomns (201408 and 201409 < these are months). There will only ever be 2...

I tried to give column names in the Header property but then the data went to blank.

Is it possible to base an expression on the crosstab query column ID? EG - I will only ever have 4 columns and I only ever want the variance of the last 2 columns. If so, are the columns 0 based and how would I reference then in an expression? Thanks

Thanks for the suggestion. I had considdered this but the column names are dynamic so I cant include a set expression.

Hi All, Im not having much luck with this - Ive tried DVar but maybe Im not understanding the function correctly. I have a crosstab query that will only ever return 2 columns of data (sales for the current month and the previous month). I want to add a column that will show the variance...

Thanks - Far better way :)

Hi All, I have been using the below code for a number of years to send reminders to Outlook and colour them red (my category colour for certain items). I've been asked to roll out this code to all members of my dept but the category for other people assigned to the red colour is different to...

Hi All, I'm having trouble thinking of a way to create a formula to work out ratio of cost. The table below shows what I want to see. My query pulls out the Cust ID, number of days, and USD value (it shows how quickly customers are paying their bills). The Ratio I've manually added and...

Thanks guys for all the useful suggestions. Im not a developer and the way I had envisioned wasn’t working which is why I asked for help - Probably could have done without the more discouraging comments.

Because its dynamic. If the latest month in the table is 201312 I want the latest 6 months (between 201312-5 and 201312). If the latest month in the table 201401 I still want the latest 6 months (between 201401-93 and 201401). The reason I need to show "If Right(DMax("[MyField]"...

Thaks for the assistance. I want to create a 6 month date range eg: 201308 to 201401 (Aug to Jan). I can easily deduct 5 or 93 to get the correct range that I want but i need to determine wheter the last 2 digits (representing month number) should have 5 deducted or 93. Doe that make sense?

The field type in Number

Hi All, I'm sure this has annoyed others and hope someone knows of a simple soloution. I want to create an IF statement based on: If Right(DMax("[MyField]", "[MyTable]"), 2) < 06 Then But VBA automatically removed the preceding 0 showing: If Right(DMax("[MyField]", "[MyTable]"), 2) < 6...

Great suggestions guys - many thanks :)