I am using Access 2000 and I have a DB that is currently running four
different queries from some Forms and subforms. These queries each
have a date field that are seperate from each other that are from
those said forms. Currently I have setup the criteria for these
queries to prompt a user to enter a month #
Query Field: Month([Open Date Field])
Criteria: [Enter Month Number (1-12)]
This works fine on the indivdual queries but, I am trying to create a
report using subreports that shows all 4 queries together. Obviously
what is happening is that when I run this report, it is asking me for
a month number for each of the four seperate queries it is running.
Is there a way to take that query input (month number) and pipe it to
all four queries so the report brings up those 4 seperate queries
filtered by the month number the user specifies without the user
having to enter in a month number four serperate times?
Any help or leads would be awesome. Thank you.
1  4203 
A common approach is to open a form with a textbox on it, and have each of
the queries refer to that text box, rather than a named criteria.
--
Doug Steele, Microsoft Access MVP http://I.Am/DougSteele
(No private e-mails, please)
"Steve" <ma***********@ hotmail.com> wrote in message
news:3c******** *************** ***@posting.goo gle.com... I am using Access 2000 and I have a DB that is currently running four
different queries from some Forms and subforms. These queries each
have a date field that are seperate from each other that are from
those said forms. Currently I have setup the criteria for these
queries to prompt a user to enter a month #
Query Field: Month([Open Date Field])
Criteria: [Enter Month Number (1-12)]
This works fine on the indivdual queries but, I am trying to create a
report using subreports that shows all 4 queries together. Obviously
what is happening is that when I run this report, it is asking me for
a month number for each of the four seperate queries it is running.
Is there a way to take that query input (month number) and pipe it to
all four queries so the report brings up those 4 seperate queries
filtered by the month number the user specifies without the user
having to enter in a month number four serperate times?
Any help or leads would be awesome. Thank you. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Matthew Braumiller |
last post by:
On Thu, 2 Oct 2003, "Gary Floam" <floam@comcast.net> wrote:
>Sure you can do that. The easies way is to create a table of the last names
>selected, and join that table into the query definition.
>
>If you write your own SQL, you can create a string something like
> where LastName in ("Smith", "Jones", "Brown")
>
>Good luck
>
|
by: nick_faye |
last post by:
hi,
hope someone can help me. i am a newbie in creating queries and i
want to create a query wherein i only get entries from my table where
values of fields 2, 3 and 4 are not zeros. for example:
field1 field2 field3 field4
one 1 0 0
two 2 0 3
three 0 0 0
my query should only get entries one and two. can somebody show me
|
by: I_was_here |
last post by:
Hey if anyone is a query pro please showoff some knowledge thx.
Ie: I have a table with :
part
price
location
qty
1 part repeats throughout the table and its price remains the same but
it has multiple locations so I'll have entries like:
|
by: RBohannon |
last post by:
I have a report with most fields populated by a query. However, some
of the fields are variable in such a way that their values cannot be
queried from a table. At present the values for these fields are
being entered by the user as parameter values when the query is run.
But there are four fields which need to be entered, and the pop-up
dialog boxes can be annoying.
I would like to have a form where the user can enter the data for...
|
by: Matthew |
last post by:
Hey ,
I have built a query which takes values from unbounded fields on a
form, and it all works except for one thing. I have a few fields in
my query that are dates. I also have a start and end date and time on
my form. So, a user will specify the start and end date, and also,
the user has the option of checking which of the time fields from the
query will have these dates as criteria.
So, one of the date fields in my query is...
| | |
by: starace |
last post by:
I have designed a form that has 5 different list boxes where the
selections within each are used as criteria in building a dynamic
query. Some boxes are set for multiple selections but these list boxes
do not necessarily need to have a selection made to be used in the
dynamic query.
In essence the form can have selections made in all or none of its list
boxes to form the dynamic query
I am looking to get some feedback in reference to...
|
by: Robert |
last post by:
I am trying to create a db for service providers by county. I'm relatively
new to db programming, but I have done quite a bit of programming ranging
from the old basic days up to doing some programming in the HotDocs
software. I've kind of accomplished my goal in access, but I'm not quite
there yet and figure I've really screwed something up.
The db consists of 5 tables I believe. T1 is the main contact info, with an
autonumber ID...
|
by: google |
last post by:
I'm developing an application for use within my company in Access 2003.
I'm new to '03, the application I did for my former employer was in
'97. The two applications have similar functionality (we're sales
offices, and I'm doing things such as associate directories, commission
calculations, order tracking, etc.). 2003 seems to have a few extra
features, but I seem to continually run in to oddities that seem like
they SHOULD work, but...
|
by: starke1120 |
last post by:
I need to write a query that has a criteria of two separate fields (one
compared to another, then a seperate one) but I can't figure out how
to do it. Let me first explain the table
id (primary ID)
FirstName (text)
LastName (text)
BadgeIn (text)
BadgeOut (text)
Damaged (yes/no)
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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,...
| | |
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...
|
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,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
