Schudule and Summery Calender calendar (1 Viewer)

kokowawa

Member
Local time
Today, 08:50
Joined
May 11, 2020
Messages
51
Hello Again best Forum Team
@isladogs
@arnelgp
the phase that i am working in now in the travel agent project is Schudule and Summery Calender , that show important information about the future work to do based on the due date , and show also summery about some other information all in based on its date int he calender day cell.

i have used 2 template calendar and tried to compine them in to one to show the results in the controls based on the requerd such as count of records and sum of amounts of records.

in the calender i want to show
sum of supplier payment based on certain date in the table
sum of collection from client based on certain date in the table
count of records for client arrival dates based on certain dates
count of records of bookings that will have the supplier cxl date due

in the attach 2 files
mycalnder which is my project
and the other file is the template that i tried to use its code to get the results from the tables or querys.

there is somthing wrong i did , i dont know what but it is not getting me any results .
as i mentioned i am not pro as you are . i need ur help
 

Attachments

  • Mycalendar.zip
    858.3 KB · Views: 161

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 14:50
Joined
May 7, 2009
Messages
19,169
can you point which Field is the following:

sum of supplier payment based on certain date in the table
sum of collection from client based on certain date in the table
count of records for client arrival dates based on certain dates
count of records of bookings that will have the supplier cxl date due
 

kokowawa

Member
Local time
Today, 08:50
Joined
May 11, 2020
Messages
51
can you point which Field is the following:

sum of supplier payment based on certain date in the table
sum of collection from client based on certain date in the table
count of records for client arrival dates based on certain dates
count of records of bookings that will have the supplier cxl date due

@arnelgp thank you for your reply
i want to collect and show the below data in each day cell in the calendar if it exist .
-sum of amounts should be paid to the supplier in calnder date based on field [totalbuyUSD] and [HotelOptionDate] field from the reservationQuery as supplier payment.
-sum of amounts should be collected based on [TotalSaleUSD] field and [clientoptiondate] from the reservationQuery as collection.
-count of number of records based on [servicedate] field in the reservationServices table as arrivals
-count of number of records based on [HotelOptionDate] field in the reservationQuery table as supplier cxl date due
-count of number of departure based on [till] field in the reservationQuery as departure
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 14:50
Joined
May 7, 2009
Messages
19,169
it's been a long work, test it now.
 

Attachments

  • Mycalendar.zip
    558.4 KB · Views: 169

kokowawa

Member
Local time
Today, 08:50
Joined
May 11, 2020
Messages
51
it's been a long work, test it now.

WOW 😄 . you are my genuse ,
thank you very much for your effort and time presented to me , i have spent days trying it but couldnt do it .

i will study what you did to repeat it if i want to add more fields to the calender .
you inspired me ,i will actually will make another calnder to have tasks schudule to the team

one thing can we hide the line that return no data , for example if there is no amounts to pay can we hide the line and text of Supplier payment
or the count of arrivals return no numbers we hide it .
only show the lines that have values
like in 1st of july show only supplier payment line and supplier cxl date due line
 

kokowawa

Member
Local time
Today, 08:50
Joined
May 11, 2020
Messages
51
@arnelgp , i am greatfull for your , i know i might ask for much ,

for showing only lines with values what do u think if we instead of using + in the line Nz(!supplierpayment, 0) + Nz(!Collection, 0) + Nz(!arrivals, 0) + Nz(!supplierCXLdateDUE, 0) + Nz(!departures, 0) > 0

we make each s in its IF alone so if the value of each dsum or dcount have its independent if to be shown in the calnder or not
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 14:50
Joined
May 7, 2009
Messages
19,169
see the changes on your calendar.
 

Attachments

  • mycalender.zip
    109 KB · Views: 178

kokowawa

Member
Local time
Today, 08:50
Joined
May 11, 2020
Messages
51
one big THANK YOU , your endless support is appriciated
i advise anyone pass this forum to subscribe in it , everyone here is helpful .
 

Users who are viewing this thread

Top Bottom