Access Query criteria based on other field of the same query

R

Rui M.

Joined
Nov 9, 2017
Messages
1
Reaction score
0
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
link queries 2
Access Determine what query to run based on a checkbox 0
Access How to Validate the query parameter before loading the form that is based on the query iteself? 2
Access stripping decimal places in query 1
Totals expression in query using the OR line in criteria 4
Access Remove rows based on multiple fields 2

Top