Search results for query: *

This is great... You bring up a point that I had not considered that may be what just might work... If I can hopefully get your assistance in completing If I use the On Open Event Procedure to specify a WHERE CONDITION.... 1. What would the structure of that expression be? 2. Where within the...

How can a Print/Report view look like a specific selected list from a query? Because what is displayed upon executing that query lists more than I desire in my Report Even going by your instructions to create my report, the desired results were not displayed. Bottom line the query lists MORE...

The post that I provided on 21 Oct 09 21:23 lists the entire list of items expected on the desired REPORT. Grouped as: Business Titles Degree Ethnicity Gender Industry Location [qry result of City, State, Country] Each of these groups will have a list of specific criteria Example Business...

Hmm, I see a potential issue starting to arise out of this Location table. That is, Location is actually a field that is created within a query AND NOT a field name in the tblPersonalData as I stated above. It is a field that is composed of City + State + Country from the tblPersonalData...

Okay, let's see if I have this correct: you want me to create unique tables for both Business Titles Locations this is due to combining several of the field values, right? I am guessing here, but really all I need then for field names is: tblUniqueTitles BusinessTitles tblUniqueLocations...

Quote: dhookom ...you have multiple Business Title values in a single field like... Yes The FORM that all values are input by the user are stored in 2 tables tblPersonalData and tblBusinessData. - Field BusinessTitle is a FREE FORM Text found within the tblBusinessData - Field Location is...

Quote dhookom Do you understand that a criteria is a filtered group or subset of records? Yes, I fully realize that the criteria that I am asking is a subset of the query results. So, the above list is a subset of ALL the 164 queried results. I don't need that total volume, simply...

User should view in either Print or Report mode, then user should be able to view AND NOT: interact simply print... TheAttrib = BusinessTitle TheValue = Advisor/Consultant..... NumOf = Count where TheValue = [Advisor/Consultant] TheValue = Attorney at Law..... NumOf = Count where TheValue =...

Quote (dhookom) Did you look at this in Print Preview? Yes, both Print and Report View Quote (dhookom) Can you explain what you mean by "specific criteria"... The end result is for the user to simply select this Demographic report from the available REPORTs listed in the DB. It then displays...

You ask if the values of Industry and Titles display... Yes, "TheAttrib" values display with a list of ALL available values for each [BusinessTitles, Degree, Ethnicity, Gender, Industry, Location] alphabetically. I am simply selecting [or attempting to] specific criteria. I have tried using...

... Oh, by the way I inherited this DB as I am the only individual here that has any Access experience at all. I am doing the best that I can with the skills I have. That is why I also would like to minimize any user interaction. I simply would like to have a Report to be self-generating...

I have been desiring to, as you call it, filter the report all along... The Grouping is as follows: Group On TheAttrib with A on Top again, this is not an issue as this point using your query as it is currently ...it is at the next level TheValue. That is why I have been trying to...

Wow, I am getting a LOT closer... not just by your last post. However, you did give me an idea that allowed the visual display to occur. I am almost where I am desiring the final display. Evidently the display is sorting alphabetically by "TheAttrib" which is fine, but then there doesn't seem...

I am not saying you have been unclear at all. What I am saying is I am not sure how the instructions you have given and that I have followed are going to give me the results I am seeking. Based upon what I am observing and NOT observing. What you have instructed me to perform works [for a...

One other quick question in addition to and regarding the previous post... Am I to have "multiple" Text Boxes within the Detail header section OR how am I to show what I desire with only two Text Boxes? Label: Industry TextLabel: Construction TextBoxControlSource: CountOf TextLabel...

Okay, I got that I should have only one group based upon "TheAttrib" and I am guessing that the Sort function is to allow me to see the values that I desire, right? Beyond that I am confused... When I create a Text box there are two objects created: Text Label AND Text Label Am I not to use...

First, I am not familiar at all with grouping/sorting so I am explaining what I am trying to do & what is observed based on your instructions Using Access 2007 Select Group & Sort Design button - lower pane displays with "Group, Sort, and Total header - "Add a group" and "Add a sort" boxes...

I have an inquiry regarding using Queries in and as the "Record Source" of a Report... I have a single Access Report named rptDemographics I am trying to gather a variety of information into and display. I have a quite elaborate and useful union query [with the aid of a developer I might add]...

Thank you for all of you assistance, yet if you look back in my initial post I stated the tables and several not all of the fields in question. Yes over time I believe that the end result has been reached... using your query last posted [edited to include all of the field names etc and more...

the queriy you just provided: SELECT Location, Count(*) as NumOf FROM tblPersonalData GROUP BY Location; returns a "Enter Parameter Value" box... although that might work for a single value from a query however, I don't see how that would do any good for a report that has multiple data...