Search results

I am trying to filter a query to give me this. The filters below is what I am trying but Date 2 is still pulling dates that are less than june 1, 2009. Date1 is filtered like this: >#12/31/2007# Between [Enter: Start Date Like 05/31/09] And [Enter: End Date Like 06/01/10] Date2 is filtered...

Thanks! Worked perfectly!

I have a query that I want to be able to change my search criteria by keyword(s). I want it to be able to ask me to enter keyword to search for so I can filter it to a report. Here is what I have tried with no success: Search for Keyword: Enter Keyword [" "] Search for Keyword: Enter...

Sorry. Your criteria worked, it was something else in the query I had to tweak to get all the records I needed. Thanks Again!

That worked with a little tweak. Thanks!

I tried your solution and it comes up with no records. I have to capture what is open which will be yes (yes/no check box= unchecked) and what closures there were during any period of time for instance between 06/01/09 and 05/31/10. I have to capture both to show on one report versus 2 that I...

I have a query that I am trying to pull information from a yes/no field that is for open studies and a date field. The date field is for studies that have closed. I need to capture all current open studies and all past closed studies that were closed during a specific time frame. Is there...

I had one of the StudID's as a Text and Not Number which caused my problems. Something I overlooked. Thanks for your help!

When I run the query. It is connected to a report. I can upload the DB tomorrow since I'm about ready to go to a meeting.

I created a form that keeps a history of inputted information for research studies. I had to keep it into three sections to be able to do other things that work fine. Yes I am trying to display the last record set for the particular PI and StudyID. Dosen't work meaning that I get the same...

I tried that as well with the same result.

I tried both your suggestions but same out come. I have the one-to-many linked to studyid. If I remove one of the three tables from studyid to entryid linked to studyid it works but gives me wrong information from that table. I don't think Last has anything to do with my issue but I can be...

I have a from the has two sub-form tables that share StudyID in link child and link master. The form works perfectly. But the information stored in the tables is creating problem when I need to create a report off of that information. I have a query that runs off of three tables. Each have...

DB is attached. On the dropdown it updates 8 fields. The other fields I fill in myself. Ideally I would like to have an enter button to insert the updated data from the form to the table below that can not be updated unless I do some changes on the form. The dropdown is information that does...

I have a combo unbound text box on a form that I need to be bound to a subform table that has three drop downs in the combo box. I can only get the first one to automatically insert itself into the table. I need all three to insert into the table.

I have a form that is set as single form and the subform is set to datasheet view. I want to show all records instead of just the last record that I created in the embedded Macro. No matter what I do I can't get all records to show. I like to have a new record on top with the rest of the...

I figured out how to have the signatures and total follow the detail section. The problem I am having is that the Ref# is now out of order. When I added the =1 group it works great except for the order. DB is attached. Thx

I like my report to total the number of patients at the end of the detail section and not forced to the Report Footer. I also like the signature page to continue at the end of the detail section as well without being forced to a third page. Attached is a PDF of what the doc looks like.

I need to add forced months in a crosstab query to give me a total for the year. Attached is snapshots of the query and report. If I can some how do this in a report that will work as well. Thx!

I want to show all 12 months even though they are not present yet in the table. January, February..... Here is the script I am using: Month: Format([Date],"mmmm") It only shows the months that are in the table. I need to show all months even though the field is empty. Is there another way in...