P puffdog Registered User. Local time Today, 22:49 Joined Jul 30, 2003 Messages 17 Sep 15, 2003 #1 Hi there,i have two field in my query ,there are field Total, Min i wan to print a report when field Total <= field Min, how i create a report like this?Could somebody tell me? Thanks all..
Hi there,i have two field in my query ,there are field Total, Min i wan to print a report when field Total <= field Min, how i create a report like this?Could somebody tell me? Thanks all..
D doran_doran Registered User. Local time Today, 09:49 Joined Aug 15, 2002 Messages 349 Sep 16, 2003 #2 second query create a second query based on your first query. you can use following... Test: [field1] > = [field2] so, above is more like where clause www.sqlcourse2.com >> free online sql course.
second query create a second query based on your first query. you can use following... Test: [field1] > = [field2] so, above is more like where clause www.sqlcourse2.com >> free online sql course.