Re: filter field for report - access97

Heather:

Here is an additional reference regarding using form controls as parameters
for queries.

http://support.microsoft.com/kb/95931/EN-US/

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


"Heather" <HWilson1@xxxxxxx> wrote in message
news:1130511352.342074.61020@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I want to create a report that shows the percent of safety audits
complete by each individual shift, based on the safety audit date.
The user has to put in the dates they want the report to pull up. This
is done in a parameter value box.
Is there a way for the user to put in which shift to pull up, based off
a field that is a list box?


.

Relevant Pages

  • Re: Query records with single Dates Automatically
    ... Here is the code for the Out of Town Report: ... both queries pull from the same table. ... -- Two Tables Attendees and Visits ... Please copy and post the SQL of your query. ...
    (microsoft.public.access.queries)
  • RE: Simple problem, simple answer?
    ... contains callers name, town, software, coments, and receiver. ... software field pulls from software table but i would like it to pull from the ... "Jerry Whittle" wrote: ... Actually a proper link to a report would be faster. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Form Problem
    ... If you are properly filtering the report it should pull the appropriate ... Dim strMsg As String, strTitle As String ... Dim strDocName As String, strLinkCriteria As String ...
    (microsoft.public.access.forms)
  • Sum of numbers
    ... I have a report that pulls numbers from one main table and 4 linked tables. ... I was hoping the control source would ... set that to ZERO as a default if no number is pulled from the 5th table. ... Can't pull something not there in the data. ...
    (microsoft.public.access.reports)
  • Re: Printing pages
    ... Then pick a nice column and show only the non-blank cells in that column. ... > I have a spreadsheet that pulls info into a report. ... pulled from page two if there is data to pull ... > Regards Dean ...
    (microsoft.public.excel.misc)