Hi there,
I have a table with the information related with the kms of our fleet company. The table as the kms at the end of the month, and i didn't put the kms at the begining of the month because i always thought it was redundant info.
Now i need to query the DB to get (kmsf - kmsi). I have tried to create crosstables and i managed to resolve the problem but always get another problem: the fields in the query of a crosstable are dinamic and i don't get always the same months and this isn't what i really want.
Is there a way to make a query that returns the value of kms_at_the_end_of_month and the kms_at_the_end_of_the last_month?
Thanks!
I have a table with the information related with the kms of our fleet company. The table as the kms at the end of the month, and i didn't put the kms at the begining of the month because i always thought it was redundant info.
Now i need to query the DB to get (kmsf - kmsi). I have tried to create crosstables and i managed to resolve the problem but always get another problem: the fields in the query of a crosstable are dinamic and i don't get always the same months and this isn't what i really want.
Is there a way to make a query that returns the value of kms_at_the_end_of_month and the kms_at_the_end_of_the last_month?
Thanks!