I have a saved query from which I build my weekly customer reports. It
queries a "Region" column which has predefined values: North, South etc.
With this same query I would like to quier one more column called "Round"
which has NON-predefined values. So when I double click on the query a
window should popup asking me what value would I like to enter for the
"Round" column. How do I do that?
Julian 5 3535
Go to the field "Round" in the query-view
Put something like [Give me the value for the Round] in he criterion row of the query
Arno R
"Julian" <x@x.xschreef in bericht news:4k******** ****@individual .net...
>I have a saved query from which I build my weekly customer reports. It
queries a "Region" column which has predefined values: North, South etc.
With this same query I would like to quier one more column called "Round"
which has NON-predefined values. So when I double click on the query a
window should popup asking me what value would I like to enter for the
"Round" column. How do I do that?
Julian
hey,
all you need to do for that is go to the design view for the query and
under the criteria for the Round field type in [Round?] and it will prompt
for you to enter the round and then only show results where the round field
equals the round value you entered.
Rob
"Julian" <x@x.xwrote in message news:4k******** ****@individual .net...
>I have a saved query from which I build my weekly customer reports. It
queries a "Region" column which has predefined values: North, South etc.
With this same query I would like to quier one more column called "Round"
which has NON-predefined values. So when I double click on the query a
window should popup asking me what value would I like to enter for the
"Round" column. How do I do that?
Julian
This is magic. Now how do I capture that in a report header? Should look
something like: North Area, Round [round number]?
This is magic. Now how do I capture that in a report header? Should look
something like: North Area, Round [round number]?
Create a textbox in the report header
Use the SAME criterion as used in the query as the controlsource like =[Give me the value for the Round]
Or (to get North Area, Round [round number] as you ask)
="North Area, Round [" & [Give me the value for the Round] & "]"
Arno R
Access needs to know
"Julian" <x@x.xschreef in bericht news:4k******** ****@individual .net...
This is magic. Now how do I capture that in a report header? Should look
something like: North Area, Round [round number]? This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Alex Stapleton |
last post by:
Whenever I run python I get
"Warning! you are running an untested version of Python."
prepended to the start of any output on stdout.
This is with Debian and python 2.3 (running the debian 2.1 and 2.2 binaries
doesn't have this effect)
Does anyone have any idea how to stop this or have even seen it before?
|
by: S.Peppe |
last post by:
Hi there!
I'm really new at this game, so please forgive me if my request is at
all irritating. I have installed PostgreSQL onto a Debian/Linux machine,
and I have just upgraded PostgreSQL via the apt-get update & upgrade
commands. However, whenever I get into the PostgreSQL interactive
terminal thus
sp@vanthoff:~$ psql -U postgres SHG
|
by: Mark |
last post by:
Hi all,
Is there a "standard" way to structure a small windows form such that it can
run non-interactively with an appropriate command line switch?
E.g, if I run the form normally I get the form's UI, but if I run it with /q
(or whatever), it runs non-interactively (perhaps logging to the event log).
I did try parsing the command line in Main(), but of course Main is static
and it's not possible therefore to use some field or method...
|
by: Anony Mous |
last post by:
Hi,
I've run into a problem. I've had postgres V8 beta on my WinXP Pro machine
for some time now, and it's been running great. Now, for some reason, I
cannot issue any queries to the database via psql. See snippit below...
------------
C:\Program Files\PostgreSQL\8.0-beta1\bin>createdb -U postgres test
CREATE DATABASE
|
by: nan |
last post by:
Hi All,
I am trying to connect the Database which is installed in AS400
using DB2 Client Version 8 in Windows box.
First i created the Catalog,
then when i selected the connection type as ODBC, then i am getting
| |
by: bblais |
last post by:
Hello,
Let me start by saying that I am coming from a background using Matlab
(or Octave), and C++. I am going to outline the basic nuts-and-bolts
of how I work in these languages, and ask for some help to find out how
the same thing is done in Python. I am not sure what the standard is.
In C++, I open up an editor in one window, a Unix shell in another. I
write the code in the editor, then switch to the shell window for
compile...
|
by: Xah Lee |
last post by:
in March, i posted a essay “What is Expressiveness in a Computer
Language”, archived at:
http://xahlee.org/perl-python/what_is_expresiveness.html
I was informed then that there is a academic paper written on this
subject.
On the Expressive Power of Programming Languages, by Matthias
Felleisen, 1990.
http://www.ccs.neu.edu/home/cobbe/pl-seminar-jr/notes/2003-sep-26/expressive-slides.pdf
|
by: Roger Trask |
last post by:
Web Server: IIS6
PHP Version: 5.2.5
Database: MS SQLEXPRESS 2005
Loaded PDO Drivers: MSSQL, MySQL, ODBC
When executing the following script ($dbName, $username, $pw, $myDSN have been changed in this post to prevent access to my test environment):
<?php
try {
$dbname = "dbName";
|
by: Matimus |
last post by:
On Apr 11, 2:32 am, Evan <xdi...@gmail.comwrote:
Do you want a custom shell that does whatever you want? Or do you want
an interactive python shell that has some custom commands?
For the first check out the cmd module
http://docs.python.org/lib/module-cmd.html
example:
|
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: 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...
| |
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: 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...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
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...
| |