Re: Drill Down to other detail

As you can tell from the delay in my responses I only work on this part-time
and I am still a novice at Access. Anyway, I am not sure of your solution of
using a form will work. My report is based on a parameter query, using the
Between option, which prompts for a beginning and end date. Once the fields
are populated, the report outputs to screen. Not every record has a comments
but the ones that do, the user may want to see what the comments are. A
couple of issues I want to clarify before trying your solution: 1) I don't
have a primary field, since we really don't have a need for one so can I use
a subform without a primary field. 2) Can I use a parameter query with a form?

Thanks for your help.

Alan

"Michel Walsh" wrote:

Hi,


Ah, that can be done with a sub-from. The "main" form list the memo (and the
primary key field, but invisible), the sub-form list the same table, without
the memo field. Place the memo field, of the main form, below the subform.


Or do the reverse (as what is on the main and what is on the subform).


Hoping it may help,
Vanderghast, Access MVP


"ahearn" <ahearn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A8FEB519-5EAC-4DC9-8458-3234E1B6FD8D@xxxxxxxxxxxxxxxx
Thanks for your response but I do not think a pivot table will work.
Basically what I have is a phone log. The fields I currently list on a
report
are the date, name and code description. The code being the main reason
they
called. What I don't list is the comments which is a memo field. This
field
could be quite lengthy so I wanted the user to have the ability to click
on
a record to see the comments rather than listing all the comments for
every
call.

I will fool around with the pivot table concept but would there be another
way to do this besides using a pivot table?

"Michel Walsh" wrote:

Hi,



Something like "Sales Analysis" form in Northwind?

It is a query PivotTable.


Hoping it may help,
Vanderghast, Access MVP



"ahearn" <ahearn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A4C9BED1-2C04-4CE2-9A35-91597B013EB7@xxxxxxxxxxxxxxxx
If anyone has used Quicken or Quickbooks, one extremely helpful feature
is
to
drill down to the detail transactions when the report is previewed on
the
screen. Is there any way to do this with Access? If not from a
previewed
report perhaps from a query?






.

Relevant Pages

  • Re: Drill Down to other detail
    ... You don't really need a primary key, but it makes your life easier. ... You can use a parameter query with a form, but it is not common to ... My report is based on a parameter query, ... Place the memo field, of the main form, below the ...
    (microsoft.public.access.queries)
  • Re: Print a field only if value is true
    ... but your data structure is unnormalized. ... show only the problems (exactly what you describe for your report). ... On this tab, is subform "sfrmRoof". ... If a checkbox is left unchecked, ...
    (microsoft.public.access.reports)
  • Re: IsNot Null question
    ... form based on Students with a subform based on Enrollment. ... Having selected courses for the various students, ... you have a main form or report based on ... other companies even if they have submitted data in the past. ...
    (microsoft.public.access.formscoding)
  • Re: IsNot Null question
    ... form based on Students with a subform based on Enrollment. ... Having selected courses for the various students, ... you have a main form or report based on ...
    (microsoft.public.access.formscoding)
  • RE: Make subform visible or not in report?
    ... I also found the same subform within ... Dave Hargis, Microsoft Access MVP ... "TKM" wrote: ... control on the report and the actual report being used in the subreport ...
    (microsoft.public.access.reports)
Loading