Show prompted Query criteria on report

NicholasSerpentine

Hi folks....I have been checking out this group and have found help
and solutions to everything I have needed up to this point. I have
created a report based on a Query to show me certain activity during a
specific period. When I run the report a prompt asks me for the start
date and end date of the period. How can I have the report show those
same dates without retyping them?

Thanks,

Nov 19 '07 #1

Subscribe Reply

3602

fredg

On Mon, 19 Nov 2007 11:21:39 -0800 (PST), Ni************* ***@gmail.com
wrote:

Hi folks....I have been checking out this group and have found help
and solutions to everything I have needed up to this point. I have
created a report based on a Query to show me certain activity during a
specific period. When I run the report a prompt asks me for the start
date and end date of the period. How can I have the report show those
same dates without retyping them?

Thanks,

Add an unbound control in the Report Header.
Set it's control source to something like:
="For sales between " & [Enter Start Date] & " and " & [Enter End
Date]

The text within the brackets must be identical to the bracketed text
in the query.

You may wish to format the dates, in which case:
="For sales between " & Format([Enter Start Date],"mmmm d, yyyy") & "
and " & Format([Enter End Date],"mmmm d, yyyy")
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Nov 19 '07 #2

Allen Browne

See:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

The article explains 2 ways to do this. Both include details of how to show
the date range on the report.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<Ni************ ****@gmail.comw rote in message
news:ce******** *************** ***********@i37 g2000hsd.google groups.com...

Hi folks....I have been checking out this group and have found help
and solutions to everything I have needed up to this point. I have
created a report based on a Query to show me certain activity during a
specific period. When I run the report a prompt asks me for the start
date and end date of the period. How can I have the report show those
same dates without retyping them?

Thanks,

Nov 20 '07 #3

Similar topics

12993

Prompted for parameter on OpenReport

by: Aaron | last post by:

Hello, I'm trying to limit a report to a list of parameters that I pass in. The report and the underlying query both use the column FirstName. Whenever I try to limit the FirstName in via the "Where" clause, I get prompted to input the FirstName parameter, even though I'm passing it in via OpenReport The syntax I tried using:

Microsoft Access / VBA

2233

Prompted Twice For Filter Criteria

by: Colin | last post by:

I created a macro that starts a filter on a query. The criteria in the query is: Like & "*" The macro is initiated by pressing a command button on the form. This works fine. However, when this form becomes an unbound subform of another main form, I'm prompted twice for the value of the filter (i.e. the group name to enter). How can I stop the double prompt when my form is used

Microsoft Access / VBA

3513

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 make a query that selects from a table as desribed below .. I have a table (Volunteer) that has a member field (memnumber) and a number of fields that are headed in various categories and are yes/no formated

Microsoft Access / VBA

4580

Query current record

by: Michael Israel | last post by:

I am new to Access. I have a form with a single record. The keyed field is PropID (number). I want to run a query from the form that will have the current value of PropID be the variable in the criteria of the query. The intent being the query returns the values of the current record of the form for a report. So, I want to code a pushbutton to run that query with the current keyed field value as the criteria and then open a report...

Microsoft Access / VBA

2252

Reports that show only some lines from a query

by: a_munch | last post by:

Hello, I was wondering if there's any way to create a report that will show only rows from a query that meet certain criteria? I can't create a second query that will pull only the records I need for this reason -- I have a crosstab query that shows data by month, and in order to show the full 12 months for the year, I have created some dummy data that has 0 for January through December. I need to have all 12 months as column headings so...

Microsoft Access / VBA

1788

don't want info to show

by: Anne M | last post by:

I have a report based on query..which is a team list with names and their role on team ie coach, assistant and player. Report is almost what I want and my knowledge is limited so I need some advice. I want the team list to show the names of the individuals and their role on team if they are coach or assistant but not if they are player but since they are based on the same field (role) how do I set it so I can get it to show only what...

Microsoft Access / VBA

7172

Add "All" to Combo Box and Use "All" as Criteria in Query

by: meganrobertson22 | last post by:

Hi Everyone- I have a question about how to add and then use the "All" selection in a combo box. I am trying to figure out how to: (1) add "All" as a selection to a combo box and then (2) how to use the selection "All" as criteria for a field in a query, which is used to generate data for a report.

Microsoft Access / VBA

2587

NotNull Query

by: Drum2001 | last post by:

I have a form that contains 8 textboxes "Textbox30, Textbox31, Textbox32, Textbox33, Textbox34, Textbox35, Textbox36, Textbox37". This form is designed to allow the user to input up to eight Department Codes. When they hit the submit button, it opens a report based off the following query: SELECT ra_report.CCENTER, ra_report.BANK, ra_report.DIVISION, ra_report.EMPNUM, ra_report.NAME, ra_report.TOKEN, ra_report.ASSIGNED,...

Microsoft Access / VBA

1431

Search to see if the criteria field in a query has something in it

by: kaosx5 | last post by:

I am running Access 2003. I would like to be able to search the criteria section in an Access query to see if it populated with anything. I have a report database that has a list box and some questions to answer to run the report. They are mant diffenet reports and the criteria can be the same for some and differnet for others. Here is how the report db works: On the form I have a multiple questions asked to fill in the criteria of the...

Microsoft Access / VBA

8330

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8850

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8746

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8523

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

6178

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

4175

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4334

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1975

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1737

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General