make a query some particular fields (1 Viewer)

Dhanu

Registered User.
Local time
Today, 03:01
Joined
Nov 28, 2017
Messages
66
finally? is over.

woooooowwwwww grande arnelgp it is working finely. thank you so much. thumbs up for your work. I cant do this without you guys.

thank you very much everyone, who spent their time to work on this.
 

Dhanu

Registered User.
Local time
Today, 03:01
Joined
Nov 28, 2017
Messages
66
No I don't think so....

Dhanu appears to have 2 new questions as a follow up ... or have you also answered those? :)

this is more than enough for me :) now I want is, I want to run a report and get printed.
 

Dhanu

Registered User.
Local time
Today, 03:01
Joined
Nov 28, 2017
Messages
66
finally? is over.

hi, can I delete these two fields shown by the attached JPEG
 

Attachments

  • 15.jpg
    15.jpg
    90.2 KB · Views: 49

Dhanu

Registered User.
Local time
Today, 03:01
Joined
Nov 28, 2017
Messages
66
I hope this is the final

hi arnelgp,

sorry for bothering you always.the query, mask and all running perfectly.
now I need,

01. As I said earlier, I want to apply commision percentage to every single customer. (like 25%,20%, 0%...etc) so is there any possibility we can add this values to the query? or we can make a new particular form or can we add another field to existing data entry form. like this picture.(refer pic 01)

02. secondly, I want to run below reports using a mask(form) which you created for me. if cannot run all 4 reports using one mask(form) we can use 4 different forms. which way is more better. I tried to make a new query and run these reports but it is more complicated for me as always.

I assume you are a busy person. if you don't have much time to look up this matter kindly let me know the steps to go forward. hope you will help me this time also.

Note: in report 04, I need to calculate total tours I don't have any idea how to do that.

thanks.

the reports as below,

REPORT 1 (participants list)

Data
Nome
Cognome
Lingua
Nave
Pick_Up
Orario
Telefono
Codice_Operatore
Tour_Operator
Tour_e_Escursioni
Adulti
Ragazzi
Bambini
total participents

REPORT 2 (general)

Data
Nome
Cognome
Lingua
Nave
Durata
Pick_Up
Orario
Codice_Operatore
Telefono
Codice_Operatore
Tour_Operator
Tour_e_Escursioni
Codice
Adulti
Ragazzi
Bambini
total participents
Adulto_€
Ragazzo_€
Bambino_€
Adulti_Totale
Ragazzi_Totale
Bambini_Totale
Quota_Totale
Percentuale
Netto

REPORT 3 (amministrazione)

Data
Nome
Cognome
Codice_Operatore
Tour_Operator
Tour_e_Escursioni
Codice
Adulti
Ragazzi
Bambini
total participents
Adulto_€
Ragazzo_€
Bambino_€
Adulti_Totale
Ragazzi_Totale
Bambini_Totale
Quota_Totale
Percentuale
Netto

REPORT 4 (TOUR)

Tour_e_Escursioni
Data
Tour_Operator
TOTALI TOUR (is there any possibility to calculate total tours ?)
Adulti
Ragazzi
Bambini
total participents
Adulto_€
Ragazzo_€
Bambino_€
Adulti_Totale
Ragazzi_Totale
Bambini_Totale
Quota_Totale
Percentuale
Netto
 

Attachments

  • 01.jpg
    01.jpg
    79.7 KB · Views: 40

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 10:01
Joined
May 7, 2009
Messages
19,169
you upload the latest db you got. we will deal with it one at a time. i think we can finish it coz tomorrow is my day off. lot's of time to code.
 

Dhanu

Registered User.
Local time
Today, 03:01
Joined
Nov 28, 2017
Messages
66
you upload the latest db you got. we will deal with it one at a time. i think we can finish it coz tomorrow is my day off. lot's of time to code.

hi, thank you very much for kindy pay attention to my request. here I attached the latest database.
 

Attachments

  • QuadroGeneraleDiPrenotazione.accdb
    1.6 MB · Views: 60

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 10:01
Joined
May 7, 2009
Messages
19,169
only managed to create 1 report.
but still it does not fit in an a4 size
paper. you have to adjust and remove
some fields.

i made a query, qryReport4.
use this as the datasource for Report4.

other reports are just listing, so
i think you can managed that. they are
same as report 1.

i wasn't able to get my day off and was
called to work today. sorry.

i add field to DiscoverMessinaCustomerT,
presentage for the percentage. it is double type
and on display as percentage.
also i change some of your field to numeric and
you must. it would be easy to calculate on these
fields now.
 

Attachments

  • aaQuadroGeneraleDiPrenotazione.zip
    246 KB · Views: 39

Dhanu

Registered User.
Local time
Today, 03:01
Joined
Nov 28, 2017
Messages
66
only managed to create 1 report.
but still it does not fit in an a4 size
paper. you have to adjust and remove
some fields.

i made a query, qryReport4.
use this as the datasource for Report4.

other reports are just listing, so
i think you can managed that. they are
same as report 1.

i wasn't able to get my day off and was
called to work today. sorry.

i add field to DiscoverMessinaCustomerT,
presentage for the percentage. it is double type
and on display as percentage.
also i change some of your field to numeric and
you must. it would be easy to calculate on these
fields now.

hey arnelgp,buongiornooo.

I was waiting for your reply. thank you very much. yes great, i can manage the rest. now I'm going to make other reports. I will let you know once finished the work.

thanks again have a nice day and a nice weekend. cheers...
 

Dhanu

Registered User.
Local time
Today, 03:01
Joined
Nov 28, 2017
Messages
66
only managed to create 1 report.
but still it does not fit in an a4 size
paper. you have to adjust and remove
some fields.

i made a query, qryReport4.
use this as the datasource for Report4.

other reports are just listing, so
i think you can managed that. they are
same as report 1.

i wasn't able to get my day off and was
called to work today. sorry.

i add field to DiscoverMessinaCustomerT,
presentage for the percentage. it is double type
and on display as percentage.
also i change some of your field to numeric and
you must. it would be easy to calculate on these
fields now.

hi arnelgp,

i was busy with my other works so I couldn't send any replies to you. the database is working so perfectly. thank you very much. your codes are perfect.I hope this post will helpful for those who search the same matter.

I have a new suggestion to do this database which is, can I add a reminder base on data field ( to do task message ) to the, QuadroGeneraleDiPrenotazioneF form or any other place (I suggested this form because its opens automatically when database open).

the message should appear 3 days before the date in the database

Ex: if I enter date as 20/12/2017 the popup should appear automatically on 17/12/2017 saying "the Records shown require action today"

kindly reply me when you have a free time
thank you.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 10:01
Joined
May 7, 2009
Messages
19,169
what condition do you have for the pop up? what fields aside from the data field should be met.
 

Dhanu

Registered User.
Local time
Today, 03:01
Joined
Nov 28, 2017
Messages
66
what condition do you have for the pop up? what fields aside from the data field should be met.

hi,
I would like to focus on data (date) field. this date is always a future date. when a customer book a tour, user enter details according to the customer said.

my opinion is when the user enters the date if we can create another field in "QuadroGeneraleDiPrenotazioneF form" as END DATE or DUE DATE(booking date -3) and this field should fill by the system automatically and will pop up 3day before the date which user entered.

as an example let say there is a customer who books a tour of 31/12/2017
user enter details accordingly and 27/12/2017 this above details should be auto pop up automatically by the system saying that "the Records have shown require action today" (or any other message)

I think now you can get an idea.

thanks.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 10:01
Joined
May 7, 2009
Messages
19,169
here you may try.
 

Attachments

  • aaQuadroGeneraleDiPrenotazione.zip
    267.9 KB · Views: 37

Dhanu

Registered User.
Local time
Today, 03:01
Joined
Nov 28, 2017
Messages
66
here you may try.

hi arnelgp ,

thank you very much, it works pretty well.
And I want to say that you are a very kind and very informative person. you and other experts gave me a big help to finish this database.


thanks again all.....
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 10:01
Joined
May 7, 2009
Messages
19,169
we're to help you.
 

Users who are viewing this thread

Top Bottom