I need some guidance with this... I'm trying to keep records of six different locations with this company. I decided not to play that much and i just put all the locations within the same table (each one has it own six columns for revenues, discounts, etc..)...not the smart way to do it but it is wha it is right now. Now, I need to compare the revenues from one year (per month) to the revenues of a different year... I have not idea how to do that... I tried combining two queries (identical) that ask each one for the year to run the query, but when i combine them i only get to input one year and get nothing... I know is crazy but I hope anyone can help me or guide me to get this done..
Darwin
Darwin
