Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Show group footer only when needed?
Hi, I have a report with a department footer with sums for dept 1, 2 & 3. Users want to add a sub total of dept 1 & 2 after dept 2 group footer. I added a DeptKind field in department code table, and set DeptKind of dept 1 & 2 as A, and DeptKind of dept3 as B. Now I set a group footer of...- eowyn12
- Thread
- Replies: 5
- Forum: Microsoft: Access Reports
-
Input mask for phone # with extension
Hi, I'm trying to set up an input mask for phone number with optional extension number. I tried !(999) 000-0000 9999;;_ It works when there is an extension, but when there isn't, it shows like this after I tab out of the field. ( ) 12-3456 7890 I tried left justfied and right justified, but...- eowyn12
- Thread
- Replies: 3
- Forum: Microsoft: Access Forms
-
Reconstruct Lost Data from Chart
Hi, Our user created a complicated XY chart with bunch of data, and he lost his data file by accident. We tried to recover the data, but couldn't. Is there anyway to reconstruct the data from the chart? I changed the chart option to "show value", and I can read some of the numbers, but many of...- eowyn12
- Thread
- Replies: 4
- Forum: Microsoft: Office
-
Change query paramaters based on different forms
I have an append query that uses a variable on a form as a criteria. The criteria of the query is something like this. WHERE ((tblLoanTrans.ControlNo)=[forms]![frmLoanRO]![ControlNo]) I have another form frmLoanDD, with similar but slightly different controls. I want to use the same append...- eowyn12
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
