Search results

Query Filter working MStef...your latest fix did it. My deepest appreciation for your patience with this problem! You're the BEST !!! Doug

Query fix creates a new problem The query I was using for my report was not configured for a MAX expression in the "total" field, now that the original problem has been fixed, the report will only show patients who have a date in the "MaxTherapyDay" field. New patients will not have any info...

Thanks MStef YUP! I'm obviously a NEWBIE... I took a quick look at the updated DBs from you, including the Dennisk fix as applied to your DB. The process makes a bit more sense to me now and I"ll take the next few days to experiment with your suggestions. I have to play with the DB after hours...

Problem continues with Query filtering! My thanks to MStef and Dennisk for their prior help with this problem. MStef... I still can't get your DB configured to run on my DB, I obviously haven't substituted the correct fields to match your design and I don't have enough Access experience to...

OPEN vs DESIGN Thanks MStef. I was trying to open the query instead of looking at it in Design view!!! I have a much better understanding of how your DB is designed and it should work for me. I'll spend this weekend working on re-configuring your DB to mine. Again, many thanks for your help...

Hi MStef I am unable to open Query1, I get a message that it's an action query, and when I select YES to open it, it will not open. I am using Access 2003, and I believe your DB is written in Access 2000. Is that a problem? With both Dennisk and your input, I will try to create a second query...

Sorry about that! The zipped filesize is too large to post... Rabbie - I'm using a select query for my report, the action query was from a sample DB that MStef had posted. I'll have to experiment with Dennisk's suggestion and hope I can figure this thing out! As I said in a prior post, MStef's...

Here is my MDB without patient info... I looked at the sample MDB from MStef, and it works the way I would like mine to work. I'm not sure how you got the 'tblWorking" dates to come up as the most current dates from the "Detail" table. The "Detail" table would be my "Download" table, so how do...

My thanks to MStef and Dennisk Got your responses, I'll give them a try and see if something works. Best wishes for the Holiday season... Doug

Thanks for your response... The MDB is in Access 2003, and I would prefer not to post the database as it contains "Patient-sensitive" information. If my description of the problem was not clear, I would be glad to answer any specific questions you might have. Again, thanks for your help, Doug

I've been generating a report using two forms for data, and everything has worked well until recently. My report contains a field which tracks Therapist visits by date. Since the subform now contains multiple dates for each patient, the report prints a line for each date, resulting in two or...

"Top Value" property didn't work Thanks for your quick reply... I tried the Top value property in the QSL table, but it seems to have effected the entire report, not just the DATE field. Now I get only one record showing on the report. The SORT to "Descending" did work however. Is there a way...

I've had great success with my database, thanks to the help received from this Forum! The newest glitch is when I generate a report. The report is based on two tables, one of which tracks patient visits by date. Since the date subreport is now collecting multiple visits for each patient, the...

It Worked! Did as you suggested, it worked like a dream! I was even able to include data from a subform into the report! My humble thanks to you for your timely help!!! Best wishes, Doug

Still having problems! Hi Paul, I tried to build a VB code for my filter using the following on the On Open command in the Event Procedure; Private Sub Report_Open(Cancel As Integer) DoCmd.ApplyFilter "STATUS = 1" End Sub The error message says that the Jet Database can't find the object...

Thanks Paul Your help and quick reply is great. I'll try the Wherecondition at OpenReport first, I'm not quite sure about applying a newly-created query to an existing report. It's probably VERY easy but I am a novice at this point. Thanks again, Doug

As a new user of Access, I've created a number of forms for use in tracking medical equipment. After creating a report from the main "Contacts" table, one of the therapists has suggested that I narrow the report's scope to "Active" patients only. The main form has a field to track "patient...