Thanks, I didn't think it would be that easy. I just made the report's record source handle all the totals instead of making an independent query. Works all the same.
I did plenty of searching on this topic here and didn't find anything helpful, or atleast anything I understood.
My problem is, I have a report that displays records by doctor, and within each record for that doctor there are a series of checks. I was able to handle grand totals just fine, but...
Ah ha, but the table will be closed. I was planning on adding a new field with another form (not bound to the table). How's it done? I haven't found any helpful information on this other than a cumbersome SQL statement that won't let me supply format parameters to my new field.
Thank Neil, but actually I just realized I don't have a complete solution yet. What we've figured out so far is how to find and edit new fields in a table, but I realized that I need to be able to add a new field to my table, preferably through the use of a form and not through manually editing...
This is exactly what was looking for, and for those who are interested, there's one little suggestion I would make so that the listbox can deal with a changing amount of checkboxes, as well as speed up this procedure a bit (should only matter if you have a massive amount of checkbox fields)...
I have a table in which each row has several checkboxes (yes/no) fields. I thought that instead of modifying this data through using checkboxes on a form, it would be easier to modify this data using a listbox with it's multiselect property set to simple, so that if the user selects an item in...
I have a query where my last argument uses the following criteria:
IIf(IsNull([Query Compare]![OTHER/UNLISTED]),[Patient Information]![OTHER/UNLISTED],[Query Compare]![OTHER/UNLISTED])
[Patient Information]![OTHER/UNLISTED] is null (as far as I can tell, there is nothing in it and no spaces)...
Hello - and I may as well get this out of the way, I'm painfully new to Access, sorry - but I'm taking on what I believe to be a simple project, and one of the problems I've run into is that I can't get any of the items in a multi selection listbox into a table.
Now, I want to back up a step...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.