Search results

  1. P

    Loops, VBA, reports, exports

    Ahh, yes.. as long as I put in force new page on the EID footer section it worked great without a page break. :-/ Man... sometimes you just need to walk away and come back. You gave me some good ideas and it worked. Thanks guys! :)
  2. P

    Loops, VBA, reports, exports

    I tried a combination of both of your suggestions which almost does the trick except that it puts an extra page in after each employee. I grouped on EID and kept the whole group together on one page while putting a page break in the footer EID section. If I put a page break in the header EID...
  3. P

    Loops, VBA, reports, exports

    Hmm, tried this and nothing. :(
  4. P

    Loops, VBA, reports, exports

    Hello, All! I'm hopeful that anyone could help me out with a slight problem of mine. I am trying to accomplish this: There are two controls on the form where a button is (form named ExportSelector) which the user indicates which department and what time frame they want. I have a button...
  5. P

    Calculating difference between two records

    What you think is table 3 is the inner join of another query.
  6. P

    Calculating difference between two records

    Right now I am taking an old database from MS DOS and converting it. This is what I have to work with at the moment. When time goes on, I will change the Identifier
  7. P

    Calculating difference between two records

    I understand unique identifiers. Either way, that doesn't solve my problem. :rolleyes:
  8. P

    having difficulty with WHERE Clause

    I still have not figured this out as of yet. I have gotten further with the database. i reposted this under a different thread about comparing two records in the database
  9. P

    Calculating difference between two records

    Hi guys, I have a problem. I have gotten quite far with my Access database with ONE thing left to do. And I have hit a wall. To give you a background on it: The database stores people's testing results It has two tables: One with the person's information and another with everyone's test...
  10. P

    having difficulty with WHERE Clause

    The Employee table has basic information: LastName, FirstName, SSN(Primary Key), DOB. The TestRecords table has ID(Primary Key Access keeps track), SSN, TestDate, TestResults (which is 14 fields Right and Left ear results from different dB testing levels), and TestNumber. The data for the...
  11. P

    having difficulty with WHERE Clause

    I will give you the background of my access database. It stores information for patients that come in and get their hearing tested. There is an Employee Table and a TestRecords table. So, every employee could have multiple records associated with it in the TestRecords table. According to OSHA...
Back
Top Bottom