Search results

This was great ... but actually, the batching plant is not fixed, how can i make a dynamic and what query for sub report that you told me. can you explain it to me. Seriously I have no idea to make this kind of report. Thanks for listening and helping me, Dio

Wow .. your good .. thanks for the quick reply ... ok, now i'll learn your file first ... thanks for everything, your very helpful With many thanks, Dio

Hello all, Is it possible to create report like MS Excel. Here is the sample data - Excel File (The kind of report) - Access (Sample Data) PS: Or maybe with multiple value in crosstab query? Is it possible? Please if anybody can help me, I'm really grateful With many thanks, Dio

Hello all, Is it possible to create report like MS Excel. Here is the sample data - Excel File (The kind of report) - Access (Sample Data) PS: Or maybe with multiple value in crosstab query? Is it possible? Please if anybody can help me, I'm really grateful With many thanks, Dio

Hey ... I got it .. i use cross tab query ... Anyway can I ask some more if i have difficulties on this. With many thanks Dio

Thanks for your reply, but I already know how to make the report like you explained to me. But how about to make the report to look like the Excel File that I attached. Better to use the 'tmp' Query to get the plant name. Can you help me? I really need this kind of report. Thanks in advance

Thanks for the quick reply, I'm new with access, Anyway here is my sample data like you asked for. I would be grateful if you can help me with this. With many thanks, Dio

Hello all, Is it possible to make a report like Ms. Excel. here is the sample of excel files. Thanks, Dio

Hello all, Is it possible to make a report like Ms Excel. here is the sample of excel files.

Hey I got the answer how to change the Week Number ... DatePart("ww",[ProductionDate],2) and change .... Weekday([productionDate],2) to make monday as the first day of the week ... Thank you very much for your help ...

The sum come up after Saturday, but i want to show the sum after every Sunday. I Think I Group by Week Number, i.e. DatePart("ww", [DateField]) is wrong because it's always end in every Saturday. Should be end in Sunday. Where is my mistake? Can you please help me? Thanks, Dio

Nothing change ...

I have no idea how to set Monday to Sunday as the begining of the week and end of the week. Here is my files..

Still the same ... the week end in saturday and begin in sunday. I'm using your steps; - Format([DateField], "mmyyyy") - DatePart("ww", [DateField]) - WeekDay([DateField]) can you explained to me how to start the week on Monday and end in Sunday in more details. Sorry if i have too many asking...

Thanks for the quick response ... it very useful for me, anyway the step you explained to me very good, but I need the week start in monday and end in sunday. I have follow all your step but still don't know with where to put Format([DateField], "dddd", vbMonday). With many thanks, Dio

Hello all, Can anybody help me. I need to query a date to become weekly. The criteria is like: The week begin in Monday and end in Sunday and must continue until end of the month, to generate report like: DayName | Date | Production Monday Tuesday...

The query is Query1, The Result that i cannot get is in Forms -> pivot_tbl_sub_riskSummary. It should be display all the RiskRatingDesc no matter the filter selected, like the LocationZone and Name field in pivot table. Thanks

Almost forgot, I'd include RatingID to QRY_TBL.

Or maybe I will use the RatingID to QRY_TBL? But I realy don't have any idea to make the query.

Thanks for the quick reply, I'd realy appreciate it. The main idea is to show all the LocationName based on LocationZone and all the RatingDesc with the comparasion criteria from TABLE_2 and QRY_TBL. Even with all the RatingDesc Field who do not have any value in QRY_TBL. The goal from the...