Search results

I actually went out and bought another version (Office Professional Pro 2016) and totally uninstalled Office 365 and then tried the action query again and the Red Run icon again did not function at all. So that is why I believe there is something within my computers settings that has been...

NO. I clicked that on entering the db.

I have been using Office 365 and have not been able to get any Access Action Queries (append, update, delete)etc to work. The regular query works fine, but the "action" ones do not respond to the Red Run Icon at all. When I click on the Red Run icon after having chosen a field to add to for...

Thanks, I got it. It has been a long and interesting ride. Your help has been fantastic. Thanks.

Do you mean by "force it manually" to just place the =Sum[CD1] expression in the footer in a txtbox?

Yes, Sum is available to me in the one you sent to me. In mine originally Sum was grayed out. From what I can see, you just changed the query to add the CD1 and CD2 fields with the code you had sent to me. Then you placed CD1 and CD2 on the report. Is that all that was done. If so, I...

So it seems we have come to the end. I tried to use the Sigma icon and everything was grayed out but Count Records. You used the same icon and Sum was not grayed out. Is there any explanation that you can think of to explain why that might be? I knew about the Sigma icon to sum a field, but...

Yes. Fantastic. How did you get it to create the sum?? I see you used =Sum[CD1] but did you just assign that to a text box on the footer or did Access actually do it via the Sigma icon in the Design Tab? This does exactly what I was looking for. Thanks again.

I wasn't aware that it was possible to write an expression in the query builder. So I see what you have done. When I run the print preview it works properly because the code works properly. But, when I try to create a total using the Sigma icon in the Design Tab, there still is only count...

Just realized that when you try to run the rpt there will be no names on the report as I have removed them. Hope this doesn't cause a total crash of the rpt. If necessary put in a few names in the Patients table and use them to place data into the Transaction table.

I have been using March 1 2020 for the first and March 30 2020 to the second. As there is very little data in the Transaction table (you can add some by using the "Day Sheet" and providing new data. It then DOES figure out the correct data to fill in the two txtboxes on the right of the form...

Did that get through O.K.?

Created a zip file using the only zip creater I own. Hope this works.

What is a C&R?

I took out the address, city and zip of these patients and left their names in. What I want to happen is that the Doctor's secretary uses the "Day sheet" to clock in each patient and what transaction occurred. That is stored in the Transaction table. Then monthly I want a report to be...

Did you see the table structure I sent yesterday above? Including it again. The report is just to supply a Bill to each patient monthly based upon their access to the Doctor that month. Some have more than one interaction (he's a psychiatrist), That is why I need to Sum the txtboxes on the...

You asked me to send you a working sample so that you can see the code I am using, but the code is simply what you sent to me. =IIf([Code1]="AL" Or [Code1]="AS",[Split1]*[Fee],[Amount]) placed in the control source column of the Data Tab. If I remove it from the control source then all of the...

I have no idea how to suppy a working sample of the database. I think it will be easier to send the full workspace. I you can inform me how to supply you with a working sample, I will do it. If not I'll send the full workspace with all its data. Please let me know.

This should work. What else can I send?

I see the tables didn't survive changing from docx to txt so I'll try again.