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?
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.
