Hi - hope you are well
Yup, how's your son?
Do you understand my question
just reading it - also, is there an uploaded copy of the database?
not yet. I felt that I needed to get this solved first to correct the previous problems
ok - well the usual way is with a subform but they can be quite clunky
let me load up the previous copy and take a look at that form
I have queries made for the data and I could go directly to the tables without the queries?...
yes - that would be one way of doing it. Do you know which items on that form would relate back to which query/table?
All the questions about periods, cycles, come from the Health Background. Actually those results to the questions would have been asked already, they just need to be visible on this form, not necessarily changeable. The advocate would need to see them here so she could talk about the options available to the client at this date.
I would also like the client's name at the top of the form....which comes from the tblClientIdentity, as well as the center's id number for the client from that table. So do I keep the form source blank and make all the field sources individually to each query or table?
yes, I think given the information required and the sources concerned then each field source will need to be controlled individually
so do you leave the form's control source blank?
yes, the overall source can be blanked
what then is the advantage or necessity of the query as a form source?
I guess that is for far simpler databases - a lot of people use Access in a very limited manner and not with the rich information you are using it for
and if a single form source works it can make troubleshooting easier
okay, should we, could we address the counting expressions in queries where we count the number of field entries in a multientry field (within the same record).
yes - what part of the database do we need to be in?
qryClientVisitDetailsAndResults.nmPeopleAttendingThisEWYLSession needs to count the number of entries in grpWhoElseParticipated and add 1 to the quantity
that will give me the syntax to use in other places if needed. Then at a later date I will need the syntax for counting between records within certain date parameters for reports.
ok - am looking at it now
it should just be a case of putting the item in quotations
and then following it with the + 1
although the query isn't working on the copy of the database I have at the moment
so write me the one expression. in the query I put nmPeopleAttendingThisEWYLSession: Count ("grpWhoElseParticipated" + 1)
no, nmPeopleAttendingThisEWYLSession: Count ("grpWhoElseParticipated") + 1
nmPeopleAttendingThisEWYLSession: Count ("grpWhoElseParticipated") + 1
that should be the one
okay, will try these. Can I contact you tomorrow if I am reach a snag. What time is good.
sure - no problem
Will be online from 2PM EST again
so anytime after that which suits
See you then if necessary, other wise will rate you then. Thank you for all your help
happy to help!