planning sur access 2016

%3CLINGO-SUB%20id%3D%22lingo-sub-1716075%22%20slang%3D%22fr-FR%22%3Eschedule%20on%20access%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1716075%22%20slang%3D%22fr-FR%22%3E%3CP%3EGood%20morning%20to%20all%20of%20you%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20been%20trying%20to%20solve%20a%20problem%20for%20weeks%2C%20but%20I%20can't%20find%20a%20clear%20explanation%20for%20my%20goal.%3C%2FP%3E%3CP%3EI%20should%20point%20out%20that%20I%20consider%20my%20ACCESS%20level%20to%20be%20average%2C%20so%20I%20ask%20you%20for%20leniency.%3C%2FP%3E%3CP%3EI%20am%20in%20the%20process%20of%20creating%20a%20database%2C%20such%20as%20an%20office%20application%2C%20which%20gathers%20all%20the%20information%20for%20project%20management%20on%20a%20commune%3A%20this%20therefore%20takes%20up%20the%20elements%20of%20projects%2C%20grants%2C%20public%20contracts.%20it's%20pretty%20accomplished%2C%20but%20I'm%20missing%20the%20icing%20on%20the%20cake%3A%20a%20schedule!%3C%2FP%3E%3CP%3Eso%20I%20have%20several%20tables%2C%20(projects%2C%20grants%2C%20markets..)%20in%20each%20of%20them%20there%20are%20dates%20with%20fields%20such%20as%3A%20date%20of%20the%20WB%2C%20date%20of%20the%20city%20council%2C%20date%20of%20the%20launch%20of%20the%20market%2C%20start%20of%20work%20etc.%3C%2FP%3E%3CP%3EI%20want%20to%20make%20a%20schedule%20that%20will%20come%20in%20the%20form%3A%3C%2FP%3E%3CP%3Eonline%20(or%20first%20and%20second%20column)%3A%20the%20name%20of%20the%20operation%2C%20type%20of%20operation%20(e.g.%20rehabilitation%20kitchen%2C%20mastering%20of%20work%2C%20then%20in%202nd%20line%20rehabilitation%20kitchen%20works%20(corresponds%20to%20several%20phase%20of%20a%20project))%3C%2FP%3E%3CP%3Ecolumn%3A%20a%20calendar%2C%20day%20by%20day%2C%20standard%20perpetual.%3C%2FP%3E%3CP%3Eand%20in%20each%20day%20of%20this%20calendar%2C%20the%20information%20relating%20to%20the%20name%20of%20the%20field%20that%20contains%20the%20date.%3C%2FP%3E%3CP%3EI%20explain%3A%20in%20the%20market%20table%2C%20I%20have%20a%20%22launch%20date%20consultation%22%20field%2C%20which%20would%20have%20the%20information%2024%2F09%2F2020.%20on%20the%20schedule%20I%20would%20like%20to%20see%20the%20name%20of%20the%20field%20related%20to%20that%20date%20and%20the%20operation.%3C%2FP%3E%3CP%3EI%20do%20not%20know%20how%20to%20build%20the%20schedule%20(or%20calendar)%20or%20how%20to%20make%20the%20name%20of%20the%20field%20appear%20(and%20not%20its%20contents)...%3C%2FP%3E%3CP%3EI%20hope%20someone%20can%20enlighten%20me%3C%2FP%3E%3CP%3Ethank%20you%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1716075%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Bonjour a tous,

 

je cherche a résoudre un problème depuis des semaines, mais je ne trouve pas d'explications claires pour réaliser mon objectif.

je précise que j'estime mon niveau ACCESS moyen, alors je vous demande indulgence.

Je suis en train de créer une base de données, type application de bureau, qui regroupe toute les informations pour la gestion de projets sur une commune : cela reprend donc les éléments de projets, subventions, marchés publics. c'est plutôt abouti, mais il me manque la cerise sur le gâteau : un planning !

j'ai donc plusieurs tables, (projets, subventions, marchés..) dans chacune d'elles il y a des dates avec des champs tels que : date du BM, date du conseil municipal, date de lancement du marché, début des travaux etc...)

je souhaite réaliser un planning qui se présentera sous la forme :

en ligne (ou en première et 2eme colonne): le nom de l'opération, type de l'opération (ex : réhabilitation cuisine, maitrise d’œuvre , puis en 2eme ligne réhabilitation cuisine travaux (correspond a plusieurs phase d'un projet))

en colonne : un calendrier, jour par jour type perpétuel.

et dans chaque jour de ce calendrier, les informations relative au nom du champ qui contiens la date.

je m'explique : dans la table marché, j'ai un champ "date de lancement consultation", qui aurait l'information 24/09/2020. sur le planning je souhaite qu'apparaisse le nom du champ relatif a cette date et a l'opération.

je n'ai pas connaissance ni de comment on construit le planning (ou calendrier) ni comment faire apparaitre le nom du champ (et pas son contenu)...

j’espère que quelqu'un pourra m'éclairer

merci d'avance

0 Replies