Search results

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 :)

Hi All, I've searched Google for a bit and can’t find quite what I'm looking for. There are a variety of date functions but I specifically want to show the date or the first working day after the 25th of each month. Eg: if 25 Oct is a Monday then result = 25 Oct if 25 Oct is a Sunday then...

Hi all, I'm having a problem with a UNION / UNION ALL query. It seems there is a application crash fault when running the query that MS are aware of and have issued a hot fix. Unfortunately it will take my IT dept some time to check and install the hot fix – If they agree to do it at all...

Hi All, I'm having trouble with something that should be straight forward. I have a table with a field I want to update with the value of a Union Query The field I want to update is Yes/No format and I can update using 0 or -1 OK. However, when I link in the union query (and check that I...

Thats great - Thank you :)

Hi All, I'm having a format problem I'm hoping someone can advise me on. I have a query (Q1) that, among other things format a date field as YYYYMM (Field1). I have a second query (Q2) whose data source is Q1. In Q2 I need to link Q1 to a table but Field1 is being reformatted as text...