Recent content by haris
-
H
Sum values in group footer where more than one records??
Hello! I have one report which has grouped records by ClientID. Every client has one or more orders. On that list I have summed values for each client separately. I don't need sum in group footer where client has only one order because it's always same value. Thank you, Haris -
H
How I can update one table from another WHERE ...?
Hello! I have two tables Table1 and Table2. Both tables have same type fields FieldA and FieldB. In Table1 both fields FieldA and FieldB are filed, but in Table2 just FieldA and FieldB is empty. Field FieldA in Table1 is PrimaryKey for FieldA in Table2. PROBLEM IS: How I can automaticaly using... -
H
Group by First letter!
It doesn't work again! Hello! On one page I need all persons which name started by specific letter. One page for A, other for B etc... I use Access 97! Thanks, Haris -
H
Group by First letter!
Hello. I have one Adrees Book. One column is Name! I need on every page grouped by First letter of name! On same page names whose started with same letter. Example, names Joe, Joan, John etc. on same page! I tried group with Sort&Group tool but I didn't do it! Thanks -
H
How I can get only last date order for all customers with more fields from tblCustome
Thanks RV! I solved my problem. I try to do this few weeks. Thank you, one more time! Greetings from Sarajevo, Haris -
H
How I can get only last date order for all customers with more fields from tblCustome
Hello! EXPLANATION: Table tblCustomers has field named Customer which is Primary Key. Table tblOrders has fields Customer (linked by Primary field in tblCustomers), OrderDate, OrderAmount, OrderDescription etc. I wish make a list for all Customers but only last Order for each of them specified... -
H
How I can get only last date order for all customers listed in report?
Hello! I have a next problem. I would like make report which contain list of CUSTOMERS with more ORDERS. I have next fields: - CUSTOMER - ORDER (AMOUNT) - DATE. I wish make a list for all CUSTOMERS but only last ORDER for each of them (specified in DATE field). I will be very gratefull for... -
H
How I can get only last date order for all customers listed in report?
Hello! I have a next problem. I would like make report which contain list of CUSTOMERS with more ORDERS. I have next fields: - CUSTOMER - ORDER (AMOUNT) - DATE. I wish make a list for all CUSTOMERS but only last ORDER for each of them (specified in DATE field). I will be very gratefull for... -
H
I need number of CURRENT, NOT TOTAL in Recordset??
Thank you Colin! If you need something call me on haris_mehovic@yahoo.com Greetings from Sarajevo, Haris -
H
I need number of CURRENT, NOT TOTAL in Recordset??
Hello. Thank you for answer, but I need number of Current record. not number of total records in Recordset!! Example, on navigation panel you can see X of Y(total). I NEED X!! Thank you, Haris -
H
Number of current record in Text Box or Label (SAME NUMBER AS ON NAVIGATION PANEL)?
Hello again! Number of current record in Text Box or Label (SAME NUMBER AS ON NAVIGATION PANEL)? Greetings from Sarajevo, Haris -
H
Thanks Rich! Specified color in listed Text Box on continuos form for current date??
Hello! Please, can somebody tell me how I can set back color for listed text boxes on continuos form or report, but for current date (In fact, Current day. Also How I can do that in Report? I will be greatfull for answer! Greetin -
H
Calculate SUM in field on main FORM from SUBFORM with criteria???
Hello! I have one problem! I have FORM and SUBFORM in that form with REFERENTIAL INTEGRITY. I have few fields in subform in datashet view! I SUBFORM I have field Amount and field Type! I have three choices on field Type and same same kind of values in Amount field! I would like calculate SUM in...