Search results

I am having trouble with an update query where I am attempting to add or combine several fields together into another field. Nothing calcs for some fields. If I recall, the problem is because at least one of the fields has blanks rather than zeroes. Somewhere I recall that in that case I need...

Thanks for your input, jal. I am sure that it will work, but I am a little dense and do not quite understand how to place the instructions. Can you help me to understand your suggested setup a little better. What I have set up in my append query already is: Field: Sum of POOLCR:POOLCR...

ACCESS2007 I am trying to sum fields and group related records together (as in a report, but in an append query) so that I can place the resulting summarized data into another table. The sum functions get me field totals, but I cannot find anything that will allow me to total by groupings in a...

Thanks to both boblarson & jzwp22. I attempted the fix as suggested by boblarson. It did not solve it, but it did lead me to the solution which I am grateful for. I noticed by reversing the tables, as suggested, that it got me a whole number with no decimal places. (I was going for the...

I have summarized a table(a) of 589 records into a table of 119 records(b). I am trying to calculate a factor in (a) as a percentage of the total in (b) for each record in (a). (a) can have multiple records for each corresponding, summarized record in (b). I do this by dividing each of the...

Access2007- Building a query to handle future input... I run an update query that does what it is supposed to do and gives the proper values. THEN I add a one more field to the source with the builder using + that has no data in it yet, the query fails and gives blanks, even though one of the...

Thanks for your response. I am using Access 2007. Yes, I have used the F4 key extensively. It gives the properties, but does not give defintions nor syntax for some of the properties. It does provide a builder in many cases, but for some of the ones I need, they are silent as to what to do...

I have looked through help and books and cannot find some items on the "properties tabs" in the report designer. One example is the "filter" property. The only thing that I get is a "zoom" and that is a blank screen. What is the syntax for that? Where can I read about it? F1"Help" has been...

Additional information... The warning flag goes away when I change the argument "view" from "Print" to "Report". Is that worthy of a warning flag? The problem is that I cannot find anything on "warning flags" and what they mean or if they are things to worry about.

Additional information discovered... The warnings only occur in the "OpenReport" action when the argument view is set to "print" or to send directly to the printer. They do not occur when the view is set to "report". Surely that is not a setting worthy of a warning?

I have tried opening the report without macros and do not find any errors. When running within the macros, I do not find any errors. It is just the frustrating warning in the macros that bothers me.

In my macros, when I use "OpenReport" I get these yellow warning triangles. I know that I am doing something wrong, but can't for the life of me figure it out and track them down. I have searched and searched and cannot find anything in any of the books nor helps. They seem to function without...

In my macros, whenever I have an "OpenReport" action, I get these yellow warning triangles with an exclamation mark in them. I know that it must mean that I have done something wrong. I have searched all over and cannot find how to track down what is wrong and how to fix them. They seem to...

Within a Macro I am able to successfully establish and display filtered records from a table with success, but when it goes to the next step of the Macro (to print the filtered records), it begins to print the entire table as if my filter were non-existant. I have looked at the report and have...

On Report Form design view, Property Sheet under Data Tab, there is a property "filter" and a property "filter on load" just below it. I am trying to find the syntax for placing a filter in that property and have been unsuccessful. I have also tried using filters elsewhere to accomplish my...

Solved!!!! I simply went into my macro and eliminated the 2nd line of the macro action which read, "RunCommand" and the argument that was with it which was "Print". I realized that the "OpenReport" action had a secondary arguement after the first part that also read "Print". So what was...

pbaldy & Mike 375: Thanks for your input. I am using Access 2007 and what I did was to consider info from both of you and varied it to get it to do the job. In the macro "Action" I selected "RunCommand" option which I already had and what I assume to be the equivalent of the VB command...

Thanks for the solution. I am already using "OpenReport" in my macro. I do not see where to place the "DoCmd.OpenReport". Is that a VB command? I struggle with VB and have not yet figured out how to place a VB command in a macro unless it is already on the list of "Actions" that are on the...

Solution: Bring the names and addresses in new from the "add existing fields" tab and place them in the detail section. Then delete the fields from the header section and adjust the the header section to fit.

I finally figured it out. Bring the name and address fields in from "add existing fields" tab and place them in the detail section of the report. The previous attempts to move them down from the header failed, but bringing them in new did. Then it was a matter of deleting them from the header...