Recent content by Konai

OK I it's very close now I think, but that query did not quite put them all on the same row. I am thinking that a max value query on each individual field, could clear this up. I am just not certain how to do that right now. I'll be looking for that, but in the meantime This is what i was...

Thank you!! that looks exactly like what i was trying to do in the first place :D I will try this immediately!

That is good to know. I had tried using sub reports as well, but it seemed to clunky to me. If I can't figure out how to get it done outside of the report I'll eventually have to do the same :(. If I get it figured out though I'll be sure to post it here. Thanks for the info Galaxiom! EDIT...

Perhaps I am not doing the UNION correctly. I do not see any option for grouping when I try and make a report from the UNION query. here is my UNION query SELECT test1 FROM PS_One UNION ALL SELECT test2 FROM PS_Two UNION ALL SELECT test3 FROM PS_Three UNION ALL SELECT test4 FROM PS_Four UNION...

Using Access 2007 I have constructed fifteen queries that are modeled like this: Query Name::PS_One SELECT CName, COUNT(CName) AS PC FROM Contact WHERE CType=1 And EDate Between Start_Date And End_Date GROUP BY Contact.[CName]; Query Name::PS_One_Total SELECT Count(PS_One.[CName]) AS ["PS"]...

It seems like calculations like this can be better achieved inside of queries. http://www.access-programmers.co.uk/forums/showthread.php?p=918591#post918591 If you could post what you have so far it would help us find out how to help you get it working. That example above only show a simple...

Ok I know now how to do the calculated fields for reports. Solution found! :D, but it was all done inside of another query so that post can be found here in the query section. http://www.access-programmers.co.uk/forums/showthread.php?p=918591#post918591

I've always found that the most simplified examples help the most. If I had the time I would make such a site for myself (but available to all like you have done) and just put the most simplified example of each thing I needed to know how to do on there. For calculated fields it was not...

Thank you again!! I'm better with making macros in VBA for excel than access so this stuff is kinda new to me. This reference looks very helpful.

I've been working on this quite a while, finally I seem to have found something that helps though. :D It was not so obvious to me as to how to get the result I needed but now i have a working query that has a result that is close to perfect. In design view I just did this. test...

Hello, ::USING ACCESS 2007 I am trying to perform a calculation on the results from 2 queries. Below those 2 queries are labled query_2 (derived from query_1) and query_3. I would like to take the result stored as PT in query_2 and divide it by CCount and then store the result so that it can be...

We seem to be having a similar problem. If anyone can answer this I'll post the solution on my own as well.

From what I have seen on other posts.. using a query is one way of putting extra calculations on a report. Which is exactly what I tried... If anyone knows why my reference to that query, ([Personnel_Count]!["Personnel_Count"]) is not working, I think it would work. Could it be that the field...

I don't know what version of access you are using, but in access 2007 I noticed some options that related to sizing (that only appeared in certain view modes) in the layout view. It really shouldn't matter how you make your report, even if you started with nothing in it, you should be able to...

Hello, I am trying to make a calculated field on a report that takes a number generated by one query and divides it by another number (obtained by another query) and display that number as a percent. I am having trouble finding the correct function to get this done with. It should look...