Recent content by jackshield

Just got to figure out how to do those things, got interrupted right in the middle of it to chase othere tangents. i will give this a try in the morning. i would thank you for all your HELP, but that would be a falicy, so thank you for doing the WORK to make my job easier. you, sir, are a...

so i will have to add some textboxes to read other textboxes. do you use the textbox names in the control source to link them? ( i really have no access skills at all )

i was hoping you wouldnt say that. my limited skills were trying to add something simple to an existing database. i think i am in over my head. i need to verify what is actually showing up on the report to ensure they are all accounted for.

can it be done by adding some kind of modifier to the count function? i tried (*)=1 and select distinct, but cant seem to get the order/syntax right.

OK, when it counts the id_number field, it is counting a query? i was able to bring up "SQL Statement : Query Builder" which had a record count of 2788, matching the info tallied in the report. it reports the id_number in multiple lines depending on how many energy sources the item has, ie, 3...

i renamed one with date, it worked, but reports a number of "2788" i think this report must be screwed?

sorry guy, hate eating up your time the "page footer" has a control with this name, it is the one putting the date on the bottom of page, can i change the existing one to another name?

sorry, i didnt get the name in when i try to name it that, I get a box telling me there is already a control with that name

it reported date/time, i will try again

sorry to be such a pain: do I name the box that, or the label for the box, it inserted both

**edit** maybe what I am asking is can I count the number of items generated by the "query" in this report? I inherited this databse, and really dont have any access skills, but stuck with it until corporate issues their new tool, whenever that may be...

Sorry, I may not have been clear... on this reports first column, "ID_NUMBER" can I count how many items are generated?

I need to know how many items appear on this report. I had a person count the items on report and they stated "1809" which did not match item count in table. the report was not reporting some items due to a null field, in another table. I fixed the null entries, but want to ensure all the...

Is that reporting the total number of items populated on this report, or the total on items on that table (OKC_MCC), or is that the same?

Upon launching file, (password = "DRAFTOKC") from the "Main Switchboard" the report "Print Entire HECP Listing" I added (copied) a text box, upper left, in header, next to "HECP" I need that to give me a total count of items reported I assumed it needed to count "ID_NUMBER" in the...