Problem: Got a 2 column label report. Something like this when printed.
|---------------------|
|name1 name2|
|name3 name4|
|name5 name6|
|name7 name8|
|name9 name10|
|---------------------|
Then I have a form that have 10 combo box which draw its data from a table which...
1) I uses Access 2002 to program a set of Query using Format("01/01/03,"ddd") which is save by default to Access 2000 file-format. However when I run this Query in another PC with Access 2000 the Query did not understand the term Format. Any ideal...I suppect its the version of VBA.
2)I know...
I was just wondering is it possible to control the color on the report if let say
Month Bank$
===== =====
JAN $100 (in black)
FEB -$100 (in red )
Is it possible?
I got this problem, I have a table full of records like these
EMP ID DATE TIME
===== ==== ====
A0001 011002 2200 (clock in time)
A0001 021002 0700 (clock out time)
==================
I would like to change them to this,
EMP ID DATE...
I got this problem
Name | Time1 | Time2 | Time3 | Time4 | Min Time|
==========================================
Tom | 12:13 | 07:00 | 17:00 | | 07:00 |
==========================================
Min Time is the Query result I need to get.
I know to Group by and sort them by...