Create a form to run a Union All Querry for specific citeria.

Jamie Pittman via AccessMonster.com

Does anyone have any suggestion how to create this form. I want to be able
to have form that has two fields [Whse Name] and [Customer Name]that allow
me to select specific parmeters for my Union Query to Look up? I have a
Querry name [Total Wharehouse Cost] that I want to be able to make easy
selections to pull specific data out? I am still new to Access and not
sure how to handle this task? Any help would be greatly appreciated.....

--
Message posted via http://www.accessmonster.com

Nov 13 '05 #1

Subscribe Reply

1276

Morning DJ

On Fri, 04 Feb 2005 23:07:32 GMT, "Jamie Pittman via
AccessMonster.com" <fo***@AccessMonster.com> wrote:

Does anyone have any suggestion how to create this form. I want to be able
to have form that has two fields [Whse Name] and [Customer Name]that allow
me to select specific parmeters for my Union Query to Look up? I have a
Querry name [Total Wharehouse Cost] that I want to be able to make easy
selections to pull specific data out? I am still new to Access and not
sure how to handle this task? Any help would be greatly appreciated.....

Look in help for "Parameter Query".

DJ

Nov 13 '05 #2

Similar topics

3184

Multiple insertion querry

by: Eric Kincl | last post by:

Hello, I have an array of data in PHP. I would like to insert each member of the array into it's own row in SQL. The array is of variable length, so it would have to be dynamic code. How would...

PHP

8054

Execute Big Dynamic SQL in Stored Procedure to Create View

by: MD | last post by:

I am trying to create a dynamic SQL statement to create a view. I have a stored procedure, which based on the parameters passed calls different stored procedures. Each of this sub stored procedure...

Microsoft SQL Server

6924

IF SELECT UNION

by: Elroyskimms | last post by:

Using SQL 2000... tblCustomer: CustomerID int CompanyName varchar(20) HasRetailStores bit HasWholesaleStores bit HasOtherStores bit tblInvoiceMessages:

Microsoft SQL Server

3601

UNION to implement default values

by: robert | last post by:

before i go flapping my gums and get deeper in alligators, wondering whether the following makes sense. i have a database which provides picklists for input. it started out with a 2 column key...

DB2 Database

2747

export variable from a form to a report using VBA

by: Thierry Schmitt | last post by:

Hello all, I m quite sure that s a common problem and even that the answer to it has been given somewhere, forgive my lack of perspicacity but here is my problem: In the vba code of a button on...

Microsoft Access / VBA

4748

sql querry : Union, Exists, IN

by: Linn K B | last post by:

I have a querry that works, but it is incredeble slow, so do anyone have any suggestions how to make this better: The table looks like this Gab(ID (key), Gid, Pid, Status, .....), mening there...

Microsoft Access / VBA

5743

sub-form: 3246 Operation not supported in transactions

by: Nico | last post by:

Hi! I use Windows XP and Access 2002 (XP) SP2 (not SP3) My company has not upgraded to SP3. My problem: -I have a form "F_BOMs" -in this form, i have a sub form called "SF_BOMs" -the sub-form...

Microsoft Access / VBA

3363

Access 2003 - double click textbox in a form to display a specific record

by: Jpipher | last post by:

Let me explain what I am trying to accomplish... Two forms -- we'll call them "Main" and "Related" A command button on "Main" runs a union query. The union query results are shown in "Related"...

Microsoft Access / VBA

1506

Problem with changing form's record source

by: zbych | last post by:

Hello everyone I have a problem with this application in Access. Application itself is supposed to help users controling parts production. The steps when using form: Step 1. This specific...

Microsoft Access / VBA

7133

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...

Windows Server

7336

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,...

C / C++

7405

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...

Online Marketing

7066

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...

Windows Server

5059

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...

Microsoft Access / VBA

4724

Couldn’t get equations in html when convert word .docx file to html file in C#.

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...

C# / C Sharp

3198

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

773

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

435

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...

General