filter field for report - access97 - Microsoft Access / VBA

Heather

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?

Nov 13 '05 #1

Subscribe Post Reply

1898

David Lloyd

Heather:

On the Criteria line for the shift field you can specify the list box value
to filter the records for only that shift. For example:

Forms!MyFormName!MyListboxName

This assumes that the list box is a single selection list box (as opposed to
a multi-select list box) and that the form with the list box is open at the
time the report is run. The user can then select the shift in the list box,
enter the dates in the parameter value box(es) , and the report query will
read the value of the list box.

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

This response is supplied "as is" without any representations or warranties.
"Heather" <HW******@cox.net> wrote in message
news:11*********************@g44g2000cwa.googlegro ups.com...
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?

Nov 13 '05 #2

David Lloyd

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" <HW******@cox.net> wrote in message
news:11*********************@g44g2000cwa.googlegro ups.com...
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?

Nov 13 '05 #3

Similar topics

Problem with 'Filter By Form'

by: CSDunn | last post by:

Hello, I have a problem with field filtering between an Access 2000 Project form (the application is called CELDT), and the report that shows the results of the filter. Both the form and the...

Microsoft Access / VBA

query by field heading

by: John young | last post by:

I have been looking for an answer to a problem and have found this group and hope you can assist . I have been re doing a data base I have made for a car club I am with and have been trying to...

Microsoft Access / VBA

using a form to filter a report

by: Afton | last post by:

I would like to make a form that filters a report by Supervisor and by starting and ending date. I have the supervisors in a combo box, and that works. However, I do not know how to code to let...

Microsoft Access / VBA

Acc97 Advanced Filter - Capturing the Filter for report Filter

by: Mike Sweetman | last post by:

I have a form Form1 which when the Advanced Filter/Sort is used creates a form(maybe) with a title 'Form1Filter1 : Filter'. When I apply the filter to Form1 it is applied, but the value of...

Microsoft Access / VBA

access97 vs access2000 advance filter

by: swilson513 | last post by:

In Access97 I was able to have an advance filter on a form that had a Like statement so when you applied the filter EACH time it would asked for the criteria. In 2000 the same filter doesn't asked...

Microsoft Access / VBA

can't filter report in Access2000

by: olle | last post by:

hi everyone. I have this code to apply the filter on a form to a report. In Access97 it worked fine but when I converted it to Access2000 the report shows all records in the table. What has...

Microsoft Access / VBA

Using a multi-select list box to filter a report

by: Fran | last post by:

I recently tried to use code for "Use a multi-select list box to filter a report" from Allen Browne in my database. I was able to add the code and adapt it to my needs, however I am getting an...

Microsoft Access / VBA

Filter a Report Date field from a form

by: DAHMB | last post by:

Hi all, Using Access 2007 I have a report called Sunday School Attendance based on a Query called qryAttendance the query is as follows: SELECT tblSundaySchoolAttendance.StudentID,...

Microsoft Access / VBA

Carrying form name through to add to filter in OnOpen event in report

by: franc sutherland | last post by:

Hello, I have a report which I filter using the me.filter command in the OnOpen event. Me.Filter = "OrderID=" & Forms!variable_form_name! Me.FilterOn = True I want to be able to open that...

Microsoft Access / VBA

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++