Detail section problem.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,

I have my report generated on Acticvate event. My query is fetching
multiple results but it allocates only the last result to the text fields.
How can I repeat the detail section and show all the records?

Thanks

Vivek


.

Relevant Pages

  • Re: Multiple Many-to-Many relationships
    ... You need to update through forms, not a query. ... display a single record from the Article table. ... needs to be able to accommodate multiple authors, ... (Newspaper, Magazine, Blog, etc.) ...
    (microsoft.public.access.tablesdbdesign)
  • Re: SQL query help
    ... the multiple where criterion. ... I downloaded a query onto a table for a test ... numeric datatypes in Access do not have precision and scale the way ...
    (microsoft.public.access.queries)
  • RE: Loops
    ... table with multiple columns 5 for each pay period, ... I run my query for the pay period ending on 01/05/07 ... you are updating multiple tables. ...
    (microsoft.public.access.modulesdaovba)
  • RE: Form For Crosstab Query
    ... My next step is to place the query on a continuour form, and add a command ... FROM (TimeRecords INNER JOIN Staff ON TimeRecords.StaffID = Staff.StaffID) ... I would like to add an additional column that sums the multiple of each ...
    (microsoft.public.access.forms)
  • Re: issue with runing Select query with condition using code
    ... You can then apply it as the Filter of a form, or the WhereCondition of OpenReport, or build the whole SQL string and apply it to the SQL property of a QueryDef. ... Splitmight be useful for parsing multiple elements in a text box into an array. ... Be sure to use the correct delimiter around the values, i.e. " for strings, # for dates, and no delimiter for numeric values. ... I'm trying to use the DoCmd.open query statement to run a Select query. ...
    (microsoft.public.access.modulesdaovba)