Search results for query: *

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...

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...

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]

Thank you very much!!! I got it!!!

thank you for your help. I don't understand your question, let me briefly explain why I asked this question: user is prompted to enter the date range, the report prints out records between date range given by the user. the user wants the date range to be shown in the text format, so... I'm...

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)...

I tried it Steve, but somehow it didn't work. :( Thanks for your time. [cheers]

thanks Steve, I played around with the ForceNewPage settings in the header/footer and detailed lines, but those are not exactly what I'm looking for. I need this setting ties with the attribute: level in other word, after all records of level 1 are printed, no matter where in the page it...

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...

Mike, thank you for your detail explanation. I tried it your way. I have 2 reports, 1 take care of category 1 ~ 3, and the other report takes care of category 4. it's not exactly I wanted, but I'll leave it this way for now. I'm wondering if it is possible to do the following thing in...

Mike, thanks for your respond. I'm very new with MS Access, never done a amended query before. Can you give more detail on that. also, can you recommand any good books on MS Access? Tracy

thanks Bastien, I'll try that.

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.)...

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?

Bastien, thank you for your reply. Can go into more detail as how when user choose the 4th choice (D), the copy of the report will be evoked? Or, how the VBA should be like? and sorry that I don't know any one who can offer you a job. I'm at New Jersey. Good luck. Tracy

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...

(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...