HI... im newbie to the Access and i want to create a FORM... i have 2 TABLE
and i want to joint the 2 TABLE in 1 FORM it is possible to joint it? can
somebody help me to create a Form?
Thnx in Advance...
( ,&&&.
) .,.&&
( ( \=__/
) ,'-'.
( ( ,, _.__|/ /|
) /\ -((------((_|___/ |
( // \ (`' (( `'--|
_ -.;_/ \\--._ \\ \-._/.
(_;-// | \ \-'.\ <_,\_\`--'|
( `.__ _ ___,') <_,-'__,'
`'(_ )_)(_ _)'
-----Original Message-----
From: se e [mailto:[EMAIL PROTECTED]
Sent: Monday, July 04, 2005 9:48 PM
To: Help Access
Subject: [Access VBA Central] Category Report
Hi
This is my second requirement, I am looking for the following
My Table name is: Orders
Fields
SL # (Auto number)
Date (Date/Time)
Client Name (Text)
Item-1-Value(numbers)
Item-2-Value(Numbers)
Item-3-Value(numbers)
Item-4-Value(Numbers)
I need a report to show the number of orders received in a given date range
in the following category
Category for each item. These categories are fixed
<=500,"USD 0 To 500"
<=1000,"USD 501 To 1,000"
<=2000,"USD 1,001 To 2,000"
<=4000,"USD 2,001 To 4,000"
<=10000,"USD 4,001 To 10,000"
>=10001,"USD Over 10,001"
I've used a query to show this and I have used the following expression
Category: IIf([Item-1-Value]<=500,"USD 0 To
500",IIf([Item-1-Value]<=1000,"USD 501 To
1,000",IIf([Item-1-Value]<=2000,"USD 1,001 To
2,000",IIf([Item-1-Value]<=4000,"USD 2,001 To
4,000",IIf([Item-1-Value]<=10000,"USD 4,001 To
10,000",IIf([Item-1-Value]>=10001,"USD Over 10,001"))))))
Another problem in my query there zero values also available, because my
data is as follows
SL# Item-1 Item-2 Item-3
1 0 10 0
2 15 0 0
3 0 0 20
I need the number of orders > zero for all the items, I tried to give a
criteria in query grid, but it returned onl the records that are matching
each other. How can we do this report, please help
---------------------------------
Discover Yahoo!
Get on-the-go sports scores, stock quotes, news & more. Check it out!
[Non-text portions of this message have been removed]
<?---- LSpots keywords ?><?---- HM ADS ?>
_____
YAHOO! GROUPS LINKS
* Visit your group " AccessVBACentral
<http://groups.yahoo.com/group/AccessVBACentral> " on the web.
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
_____
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessVBACentral/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
