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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: TracyYu
  • Content: Threads
  • Order by date
  1. TracyYu

    How to create this COUNT field?

    I have the following field: Day_1, Day_2, Day_3, ... Day_10 their value can be: X, Y, or Z Then I have a field: all_X this field is a count of total number of X's entered in the Day_# fields. Anyone has an idea how to do that? X-) Thanks in advance. p.s. all_X field is locked, so no...
  2. TracyYu

    how to keep a count of certain entries from other fields

    I have the following field: Day_1, Day_2, Day_3, ... Day_10 their value can be: X, Y, or Z Then I have a field: all_X this field is a count of total number of X's entered in the Day_# fields. Anyone has an idea how to do that? X-) Thanks in advance. p.s. all_X field is locked, so no...
  3. TracyYu

    force a new page settings

    I have a report which grouped by "level" I want each new 'level' starts on a new page. level: 1 rec.1 rec.2 rec.3 rec.4 . . . level: 2 rec.1 rec.2 rec.3 rec.4 . . . etc. how can I do that? suggestion anyone? thanks in advance [cheers]
  4. TracyYu

    change dates from numeric to text

    I have a query, which prompts user for "starting date" and "ending date", for both, user enter in "mm/dd/yyyy" format. I have a report which uses the above query. in the report I need to show the "starting date" and "ending date" as follow: Month(starting date) TO Month(ending date)...
  5. TracyYu

    force a new page settings

    In my report, I have an attribute: level, which has datetype: number. as "level" increases, records from new "level" will start on a new page in the report. I checked in MS Access 'help', it talked about some ForceNewPage Property, but I don't know where and how to change its setting as...
  6. TracyYu

    How to un/show 1 col in a report which depend on usr input in prompt?

    I'm having difficulty on producing this report, hope someone here can enlighten me. Thanks in advance. :) When user wants a report, I prompt the user for their choice: A, B, C, or D. If the user choose A, B, or C, the report has the same column titles (e.g. col_M, col_N, col_O, etc.)...
  7. TracyYu

    is taking courses in an Oracle program necessary?

    In order to take the Oracle certification exam, is taking courses in an Oracle program a must? Or is there any books can be used to study for the exam? Without joining the program, where can one take the exam?
  8. TracyYu

    How to change 1 colume in report which depend on usr input in prompt?

    I'm pretty new with MS Access, I'm having difficulty on producing this report, hope someone here can enlighten me. Thanks in advance. :) When user wants a report, I prompt the user for their choice: A, B, C, or D. If the user choose A, B, or C, the report has the same column titles (e.g...
  9. TracyYu

    Date is in short form in Database, how to have the "Month" shown as

    (subject con't) charactors in Report? Please help! I have a database which has a field: QUARTER, with datatype as Date/Time short form (mm/dd/yyyy). I need to output the month in the following form in a report: January To "Current month" "current year" It will always...

Part and Inventory Search

Back
Top