Search results

CJ - don't have that option on my ribbon, don't know what GUI is. Plog - you suggested using Group By, it has a "First" option on the total line. Neither worked. Bits - even though I had it working once I took your suggestion and made a second query to pull the duplicates out of Table 1. It...

Thank you both for answering. CJ - I am doing this in a query, I didn't write any code. I am looking at patients that were referred during a specific time frame - say, 3 months, which is the data in Table 1. I am then comparing the MR# to those in Table 2, which is all of the referrals...

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

Thanks Uncle Gizmo. Unfortunately no success. The logic works if I put in a date but if it's Null I still end up in the cc_by field. I renamed a couple of the fields because I had them the named the same as the control - I thought that may be the problem - nope. ?????????:banghead: Thanks...

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

Galaxiom - you are amazing!! Thank you so very much, importing the data, etc. to another database did the trick. Thanks again,:D Renee

Thanks Galaxiom. I am busy with school the rest of the week and will be back in the office on Saturday - I'll give it a try then. Until then -- thanks!!

Ok all - here are your answers..... JB - I'm not sure what a directory is (If you are referring to the table, doubt I put it in read-only, I was only inputting patients when I went to put in their visits is when the problem began - at least when I noticed it, but if I did I'd certainly like to...

Thanks CJ -- I can't add a new record, regardless of how I try to approach it. There are 2017 records in the table. Is there a default number of records a table will hold? If so, can I change it? I have not changed any settings. I did compact the database - without success. (see, told ya...

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

Success!!! Thanks so much for your guidance, it really helped. It was a piece of cake when I made them numbers and did a little logical addition :) Thanks again

Thanks Spikepl. I tried that and when I entered it the rule converted to <#12:10:00 AM# then I gave it a try - I got an error message when I tried 9:00 (9 minutes) so I entered 00:09, which would be 12:09 AM but it displays 9AM instead of 9 minutes. Then I looked at the format and changed...

Ok, that does make sense, thanks. So if I want min:sec - I have to have 2 data fields and concatenate them when I display/print...?

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

Ok, I knew all I had to do was post the thread. I stumbled onto it - needed the row source. :) seriously!

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

Thanks again. Have a wonderful day.

Thank you JHB!! I see that I was trying to have the report do too much work, I should leave that task to the queries and have the report do what it does best, just report the data. Thanks for everything. Mihail - JHB solved my problem but I appreciate your hard work on my behalf. I read...

Good morning fellas -- It's going to be a bit before I can devote a little time to checking out your solution JHB - I have to observe a procedure that could take all day..... Mihail - sorry didn't mean to miss answering your question. Here's my math: from the detail: (grouped on...

Ok, let me recap what you guys are telling me: - The report is corrupt --- probably not, the detail looks like it does on purpose, I redacted the data :) - This is not a simple fix. (DANG!!!) - You can see that I didn't use events, so those can't be wrong - I've used combo boxes in...