Recent content by KaylaSimmonds

  1. K

    How to calculate the number of weeks between two dates?

    Hey experts, Is there any way to do that? To input the dates into two separate columns and have a code produce the difference in dates in the next column? Rather than having to type the dates into an actual formula? I might be misunderstanding, but that is what it sounds like y'all were saying.
  2. K

    How to calculate the number of weeks between two dates?

    I found the DataDiff function while doing my own research before posting here, but I suppose I didn't get it written the right way. How do I set up the formula to grab the two dates from other spaces? Like, as I input the data for each individual deal, I put the first date in its own box and the...
  3. K

    How to calculate the number of weeks between two dates?

    First of all, thank you for your help! My database includes two separate dates related to a vehicle purchase and default payments resulting in repossession. I need to find out how many weeks passed between those dates. Example: 03/14/12 Date of automobile purchase 06/06/13 Date...
  4. K

    Two tables won't connect to the main table

    Okay, I understand #1 and #2. Will you elaborate more on the third issue for me please?
  5. K

    Two tables won't connect to the main table

    There is no true data input yet. As I'm playing with all of the settings, I just keep putting a random entry into the form for each of the first fields for every table and then close it and see the connections. Then I delete the main record from the RepoRecord table and see which other tables...
  6. K

    Two tables won't connect to the main table

    Okay, I know this may sound basic, but I cannot figure this out for the life of me. I have created a database to track information within our repossession records and it consists of 6 tables: General Info, Residency, Employment, Finances, Transaction, and Payment Schedule. Two of my tables...
  7. K

    Question Is Access the right program for this project?

    First of, thank you to all who assist me with this. My job is on the line with this. :eek: I work with a company that provides auto financing for people with bad credit. My boss purchased Access 2013 and described to me how he wanted me to set up a database to track the customers from the last...
  8. K

    Hello all!

    Hey everybody! My name is Kayla and I work at a company called Autoequation in Houston, TX. I am 25 years old and recently married to my high school sweetheart of 7 years. I am hoping to find a lot of wisdom on this forum since my boss recently handed me a project and a new copy of Access to...
Top Bottom