Search results

Having done a bit of research on this issue I am now asking in a thread. I have a multi user DB split properly and working fine.The subject of the DB is population surveys and demographics. Is it possible and how do I achieve having a user take the Front End in the field, away from the Back...

Looking to see how possible this is. With research I have not found anything yet. In the report footer you get a field with a sum. I realize you can add =Sum([xField])+Sum([yField)] for a total and this could be done for multiple fields. Thats is if everything were simple. Let's say you have...

Field1 contains a number Field2 contains a checkbox (true/false) I have a textbox in the report saying (Control Source) =Sum([Field1]) to, of course give me the sum of all of that field. I am trying to get another textbox to sum the records in Field1 for all the ones in Field2 that are...

I have only ever done the most basic tasks with Access. So far Bob and Paul have really helped. I appreciate the knowledge more than you understand.

As of this link: btabdevelopment.com/ts/samples . I have gotten and learned the "Open Generic Report with Various Criteria (simple sample)" database lesson. My question is: If this code (that does work properly): DoCmd.OpenReport "rptNotCompleted", acViewPreview, , "[surveyStatus]=" &...

I need a dropdown choice to auto populate other fields. The choices in the dropdown come of course from another table. -Main table is 'SurveyData'. -The field 'surveyStatus' is the lookup column pulling from the table 'SurveyStatusChoices'. -In that table the fields 'totalSurveyed'...