Search results

Hi, Paul. Thanks for your response and suggestion. I'm not SQL savvy enough to do that, but your suggestion did prompt another possible solution. Maybe I can use Visual Basic to restructure the data into another table using different querydefs. A bit convoluted, perhaps, but I'll give it a...

Hi, All-- I have a report request that would show results of different medical lab tests over the course of different clinic visits over the year. The requested design is to have the test type as the row heading and the appointment date as a column heading, in a crosstab-type configuration...

Hi, All-- I have a report request that would show results of different medical lab tests over the course of different clinic visits over the year. The requested design is to have the test type as the row heading and the appointment date as a column heading, in a crosstab-type configuration...

I changed the field names in the query. The query field itself has an expression: BMI2: IIf([MinofAssessDate]=[MaxofAssessDate],"N/A",[BMIL]). The report control name is txtBMIL.

Ii made the suggested changes and am still getting the error. Here's the expression: =IIf(IsNull([BMI2]),"N/A",Round([BMI2],1))

Again, good points. Thanks.

Good point. I get "#Error" in the field and the BMI-2 is the name of the control. Thanks.

Hi, all-- I am using the following expression in a report text box and getting an error: =IIf(IsNull([BMI-2]),"N/A",Round([BMI-2],1)) I am wanting to have decimals fixed at one place and, this being an expression, I get varying decimal places. I thought the "round" function would be used...

Thanks for your response. Turns out that one user had a specific access configuration through Citrix where she didn't have the appropriate rights at one place. This was causing problems both for her after I installed some action queries to the database and also to other users when she was in...

Hi, alll-- I have an A2K database on a shared drive for multiple users. I have a form in continuous forms view. There is a checkbox on each record where, if checked, the record will be printed on a report. There are two update queries for selecting and deselecting the checkbox in all...

Thanks for your response. I tried that but it didn't seem to work. That was the obvious thought. I had created the chart in the detail and then moved it to the header. Would it matter if I made created the chart in the header itself?

Hi, all-- I'd like to start using charts in a report that will show the activities/progress of patients in our program using outcome data. I would like to generate one report with each page being the outcomes for one patient so all patients reports would be generated as one report. Is there a...

Of course! Thanks for refreshing my memory. Paul

Hi, all-- If I recall, there is a way to develop an Access application that is usable for people who do not have Access installed. Is this so? If so, how is this done? Thanks! Paul

Pardon my being dense, but it seems that I have to choose some expression such as "Equal to" or "between" or "greater than or equal to", etc. Am I missing something? I tried the expression that you included for "Expression Is" as well. The field is still reformatted for all records.

Thanks for your quick response. I had tried the "Field Value Is" as "Equals To" with Null but it didn't work either. I just tried again and the same thing is happening.

I am trying to use conditional formatting for an Access report (for the first time). I put three conditions in place using the expression option in the conditional formatting window. Two conditions are based on values in other fields. The third condition, the field to be formatted, is also...

Thanks for your reply. Actually, we are using the default work group so "Admin" will be show no matter who the user is. I did forget to mention that this does not seem to happen for me (I do not get the error message), but only for the other users. I do not see any differences in the...

We have an old Access 97 database that is bringing up the error "Couldn't save; currently locked by user 'Admin' on > machine '******'. (Error 3186)." This occurs when two users are in the same form (a subform, actually) and the one user tries to exit after having entered a new record. The...

Interesting way to go but I think your idea will work for me. Thanks.