Search results

  1. R

    Matching records in tables using query

    Ok, I had this working once but now I can't replicate it..... I am comparing 2 tables, trying to find matches on a specific field then list the information from the second table. My issue is that each occurance returns data, not just the first occurance. I did a little research and found that...
  2. R

    Checking for Null in date field

    Hi everyone. I've been dinking around with this problem for longer than I care to admit. This is the deal....I have a date field on a form that needs to be checked to determine if the user needs to put data in the next field. Not everyone will have a date (CCare_Date) but if they do I want...
  3. R

    Unable to add new record to table

    Good afternoon everyone. I have been using my db for 3 years without this particular problem: I am now unable to add records to one of my tables - either through the form or in datasheet view. I have a patient table and a visit table. I put in the patient data using a form and then go to...
  4. R

    upper limit of "time" entry

    Can't find an answer to a seemingly easy question... I'm sure you can help o-wise-ones. How do I put an upper limit on the amount of time allowed in a date/time field? For example - during a heart procedure a person is exposed to radiation, it will never be more than a total time of 10...
  5. R

    New fields added to table, won't look up on form

    Hi everyone, It's really hard to put in one line what my problem is. SO.... I have this table that I built a form from - :) I added some fields to the table, most of which are look ups I added those fields to the form When I try to test the form those lookups show nothing Now...
  6. R

    Data correct on report view but not when printed

    Hey all, I'm pretty sure this is easy for you :) but I'm a relative newbee. I'm tracking some charges and want to report them based on month/year and an Early/Late (yes/no) flag within the query I created. When I wrote the report I grouped on mon/year then on Early/Late, then calculate...
Back
Top Bottom