Calculating the same field with a different date

  • Thread starter Thread starter Kassidy
  • Start date Start date
K

Kassidy

Can I take the information from the current date row and subtract a previous
dates information and display it in a text box?
 
Can I take the information from the current date row and subtract a previous
dates information and display it in a text box?
Click to expand...

Kassidy, you can see your computer and know the structure of your database. We
cannot and do not.

What is "the information"?
What is "current date row"? Access doesn't have date rows.
"a previous row" - any random row? the most recent row? a selected row?
Display "it" in a textbox - display what?

More info please! What is the structure of your table?
 
I am trying to do a calculation between numbers that were entered in the same
table on different dates. My structure is this I have one Table with all my
client information. Then I have another table that has sales entered into it
on a weekly basis. I created a form with the client info and added a subform
for all the weekly sales to be viewed while in this form. I want to take an
EndingSales column and have it subtract the previous weaks ending sales. and
have that number displayed in a text box. Does that help at all?
 
Back
Top