Replies

Thanks Tom,
I will use that if I can’t figure this one out. I already have the dynamic report built.
Just need to sort it correctly
Thanks

Rich,
When I try to sort on that field I get this message

Rich,
That sorted the colums correctly but the column labels are 24021 24022 24023 24024 24025 24026
not the mm/yy
Scott

Tom,
Should have stated that these aren’t static values. Every month a new month is added and the earliest month drops off.
Is there a way to automatically fill the column headings?
Scott

Francois,
That function worked great. I still found no reference to InstrRev in Access 2000 help file.
Thanks,
Scott

What is InstrRev?

Charlotte,
I couldn’t find a way to format the cells in the data table of the chart. I guess since it is not an actual control
I did finally get it to work by using Format(Sum([UNITS]),”#,###”) in the crosstab query for the chart. I thought I had tried that before with no luck, but it is working now on 7 different reports.
Thanks for the help Thomas & Charlotte
Scott

Thomas,
Been there, Tried that
I can get the first query to output the correct data by using:
UNITS: Format(Sum([tblMAIN_DATA].[UNITS]),”#,###”)
but then the crosstab query for the chart that uses the first query, says the SQL statement contains an invalid data type

Thomas,
That only formats the output on the screen. The actual data is still the same (no thousands separator)
I double checked that by changing it to a make table query and the “units” field in the new table was unchanged.

James,
Feel free to use it. I can’t take full credit for the code. I found some of it searching on the web and modified it and added code to meet my needs. Just make sure you set the correct startup form name in the code.
Scott

James,
Here is a little DB I put together that will do what you want plus it disables the Shift bypass
Scott

Mark,
Thanks, found it where you said
Scott

Stephen,
Here is another example for you to look at.
It disables the bypass startup, F11, and closing Access unless you use the exit button on the form.
This is in Access97 but converts to 2K without any problems.
HTH,
Scott

OK, OK…
You guys talked me into it, I’ll keep it all
I imported the first run of data and then added some dummy data to get me about 8 months worth to test with.
The fields again are:
serial_number, curent_meter ,current_meter_date, previous_meter, and previous_meter_date.
I didn’t do any processing on the import, just have the raw data.
I don’t think I need the previous data fields but kept it for now.
The dates range from 01/18/2002 to 08/28/2002 with a meter read in each of the months.
I don’t need a running totals query, I just need to subtract the current_meter for the latest date from the current_meter 6 months back.
I’ve been playing with some queries to pick out those 2 values to subtract but can’t seem to figure it out.
Can you some ideas?
Thanks,
Scott

Roberta,
I misunderstood what you wanted
Here is a re-do of the db.
This will do what you want
Scott