I have a rather complex database written, that works
great for the first 25 records. After that, one of my
queries just stops adding records to the query. all of
the tables that the query draws from add records
appropriatly,but they do not show up in the query. I
have tried to check to see if there in a max number set
for the query, and there appears not to be one. I have
tried creating a report from the query, thinking it would
list all the records, but no luck, it just lists the 25.
Can you help please (my boss really likes the database,
but I can't release it to him with this glitch!)
Re: Combining records from two queries ... The list in each case has to have the same number & types of fields (for example, if the first Query begins with a Date/Time field, the second one should do so as well). ... If I understand this, I should be able to take the results of my two queries and 'stack' the two sets of records one on top of the other, yes? ...tblMentors comprises Subject Mentors and Professional Mentors and the Placement subform has a combo for each - the Subject Mentor combo puts the chosen MentorID in the SubjectMentorID field and the Professional Mentor combo puts the chosen MentorID in the ProfessionalMentorID field. ... I can produce a query that shows all Subject Mentors and another that shows all Professional Mentors but I can't produce a query that lists them all in terms of seperate records. ... (microsoft.public.access.queries)
Re: How do I verify a valid sql statement programatically ?? ...recordset, ASP, and javascript. ... the ASP session to minimize generating the query from the DB with different ... parts of the system that generated record lists would use the same list ... Many places in our system generate dynamic queries based on various ... (microsoft.public.sqlserver.programming)
RE: Weird Problem with a Subreport ... Ok for the sorting i will try to explain it to you. ...query by writing the SQL I didnt include the Place holder field, ... Do you have a text box in the Goup Header?... I have a header of shutdown in front of the whole list but the two lists... (microsoft.public.access.reports)
RE: Weird Problem with a Subreport ... Now I need to make reports for the lists for all ... a save as for the reports and just change which query they are getting the ... and used sorting and grouping to sort by the placeholder and all is well!!!! ... Do you have a text box in the Goup Header?... (microsoft.public.access.reports)
Re: totals ... >> Piggybacking on John Spencer's reply, I would define a set of Queries to ... >> This Query lists any time slot that is used on a given date. ... >> This one lists how many time slots are scheduled in at least one room on ... (microsoft.public.access.queries)
