Search results

YOU ARE A GENIUS!!! WORKS LIKE A CHARM NOW! MANY MANY MAHALO's (FROM HAWAII) NICK

Will try.. Thanks! Nick

I'am sitting here scratching my head in total confusion. I have an action button in a form that runs a macro. This macro is a one-step macro to close the form I have open. When I click the action button, the macro dues not run. An error message pops up that says: This action can't be carried...

Hello, Does anyone know how to have a query criteria point to a certain table; field; & record? This table that I want to point to is going to be updated by the user to specify what record he/she wants to print. I know there is something like a user input box that could do this, but I am just...

Thanks for the reply! Because I do not know VBA, could you tell me what to research or point me in the right direction so that I can perform this function? Thanks

Inputbox value to be stored to a particular table/row Hello, Could anyone guide me on how to get a macro to run an inputbox that would take a users input and edit a particular field of a certain record in a table? PHEW! The other question is, how to get a query to use this particular value...

EUREKA!!! Got the two queries, queried effectively. The reasons I was having the problems with the results were: 1) I did not link the two queries correctly, and, 2) I was using the SUM function to sum up the results when I did not need to sum anything since the results were already totaled...

Will try the query again and will read up on how to do reports and will jump right into both today! Thanks so much Pat for your guidance and all the super people in this forum!

OK, I found the problem. Nothing was wrong with the formula; it was the query that was retrieving the same table record multiple times due to another related record having multiple records relating to the first table. This caused multiple instances of the same data to appear and consequently...

Thanks for your input thus far! I think the problem lay in my Totals Query. I'm doing some troubleshooting today to see if I can narrow the problem down. I truely think it is not the equation that is messing things up. I think it is the query somehow adding more rows with the same data than...

OK, I'M IN DISTRESS! FOR THE LIFE OF ME I CANNOT FIGURE THIS OUT! I uncheck the only row that is checked yes and the query calculates 0 instances. I check only one row and it counts it twice. I tried other rows and found too that it calculates these twice. I thought it might have to do...

Hello again! I am now trying to sum a YES/NO field using an Expression in the Totals field of the query as follows: Abs(Sum([myfield])) I know for a fact that the total should equal 1, but the results keep on coming back as 2. NOTE: I have many records but of all the records, I only checked...

Thanks A Bunch! The Nz() Function Worked Like A Charm! Aloha! Nick

Hello all! Can someone provide advise? I am running a query against one table. There are a total of 5 fields in this query, four of which are from the queried table and the other field is an expresssion that adds the four other fields. For example: FIELD5: [FIELD1] + [FIELD1] + [FIELD2] +...

Azzie, I'm glad I'm not the only one. Those with more experience probably know the answer by heart, but for us newbies, it is very frustrating when something so simple just does not work. ANY PROs OUT THERE .... HELP! Thanks, Nick

Hello, Could anybody help me understand why I can use a single field in a query, put a count (from the Totals view) on this field and display the total occurances for this field, but I cannot get any count to display as soon as I enter a criteria to filter out this field to obtain the filtered...

Good day! I am a total newbie at Access and have a question. Is it possible to run totals off of a query? For example: I have a simple test table with 3 fields: ID <autonumber> Field1 <number> Field2 <text> I'd like to run a query that filters out records based off of field2 and count & sum...