need help in this query - Microsoft Access / VBA

khan

I have 2 queries one is called totalDues(derived from table
AccontRecieveable) and other is totalPaymentsmade(derived from
tblPaymentsMade).
totalDues have (CustomerID, TotalDues) and totalPaymentsMade has
(CustomerID, TotalPaid). I want to combine these 2 so I could see how
much is still due or nothing.

I was combining them in this way
(customerID,[totalPaymentsMade]![TotalDues],[totalPaymentsMade]![TotalPaid],
stillDues:[totalPaymentsMade]![TotalDues]-[totalPaymentsMade]![TotalPaid])

this is when you see query in design view.

when I run this it asks me for perameters totalPaymentsMade and
TotalDues. can any one help how i can get the "stillDues"

Nov 13 '05 #1

Subscribe Post Reply

1006

David Lloyd

I may not understand all the details of what you are attempting to do,
however, from your post you state the TotalDues field is in the totalDues
query. Therefore, from your description, it would appear that you make this
change. For example:

(customerID,[totalDues]![TotalDues],[totalPaymentsMade]![TotalPaid],
stillDues:[totalDues]![TotalDues]-[totalPaymentsMade]![TotalPaid])

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

This response is supplied "as is" without any representations or warranties.
"khan" <ah******@gmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
I have 2 queries one is called totalDues(derived from table
AccontRecieveable) and other is totalPaymentsmade(derived from
tblPaymentsMade).
totalDues have (CustomerID, TotalDues) and totalPaymentsMade has
(CustomerID, TotalPaid). I want to combine these 2 so I could see how
much is still due or nothing.

I was combining them in this way
(customerID,[totalPaymentsMade]![TotalDues],[totalPaymentsMade]![TotalPaid],
stillDues:[totalPaymentsMade]![TotalDues]-[totalPaymentsMade]![TotalPaid])

this is when you see query in design view.

when I run this it asks me for perameters totalPaymentsMade and
TotalDues. can any one help how i can get the "stillDues"

Nov 13 '05 #2

Similar topics

Need Query without Union and minus.

by: Rama S | last post by:

Hi, We need a query which retrieves option_code, for a plan from OPTION table which are unique in (market, "ALL"). I have an example below PLAN MARKET OPTION_CODE RATE...

Oracle Database

Need Query Help

by: PenBlast | last post by:

I need a SQL query that will return row1 and 2. The rule would be "2 (and only 2) occurences of Store_Number where Forms_Count is not the same. Store_Number Forms_count 3 5 3 ...

Microsoft Access / VBA

Need Query by Month when date written as **/**/2004

by: bmoos1 | last post by:

I need to make a Report of all people starting in 2004 by "Date Requested". Dates are entered as mm/dd/yyyy. I have a query that has all the people that started in 2004, but there are numerous...

Microsoft Access / VBA

Need Query Help.. Urgent....

by: write2ashokkumar | last post by:

hi.. i have query like this.. select id,name from tbl where id in(5,2,4,1,3); When i execute the above query.. i get the result set with ascending order by id by default....

MySQL Database

Need Query to return multiple rows per record in layman's terms

by: jennk | last post by:

i am working in Access 97, our database tables are linked from ODBCsqlsvr (not even sure what that means). i have a table where each record has a unique customer and their order information. there...

Microsoft Access / VBA

Need query to return rows that don't match

by: Terry Olsen | last post by:

I have two tables each with one column of serial numbers. I need a query that will return only the serial numbers from Table1 that aren't in Table2. I need it to also return the serial numbers from...

Microsoft Access / VBA

Need Query... Urgent Please help....

by: write2ashokkumar | last post by:

hi... i have the table like this, Table Name : sample Total Records : 500000 (Consider like this) Sample Records: id ------------ name

MySQL Database

Need Query.. Help Please...

by: write2ashokkumar | last post by:

hi... i have the table like this, Table Name : sample Total Records : 500000 (Consider like this) Sample Records: ----------------

Oracle Database

Need Query help please...

by: write2ashokkumar | last post by:

hi... i have the table like this, Table Name : sample Total Records : 500000 (Consider like this) Sample Records: ----------------

Microsoft SQL Server

need query hw to select last 3month,3 week, only friday only sysdate using dual table

by: karuppiah | last post by:

Hi All, i need query,how to select last 3 month ,last 3wek,last 3 days , this last 3 month and 3 week should be friday, using sysdate from dual table, there is no exsting table, pls any one help...

Oracle Database

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

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

What is ONU?

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

General

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

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

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

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

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