Another Access Homework Question

Create a query based on the tblCustomer and tblPurchase tables that will concatenate the member’s first and last names (separated by a space) followed by the date they made a purchase. Name the concatenated field Purchase Details. Use a comma to separate the full name and date, in that order. Save your query as qryPurchaseDetails … Read moreAnother Access Homework Question

How can I update a form field’s Control Source to request a count (from a SharePoint list) of items that match an account number currently displayed in the current form record’s Account Number field?

So, I have the following Control Source setup in an unbound field in a form to display a number count of the # of specific items in a SharePoint list… =DCount(“[ID]”,”SharePoint List”,”[Status] = ‘Pending'”) …but how would I update this Control Source for an additional, unbound field that would make the same query, but ultimately … Read moreHow can I update a form field’s Control Source to request a count (from a SharePoint list) of items that match an account number currently displayed in the current form record’s Account Number field?

Show Common Value

Hello! I haven’t used Access in years (literally), and I’m back for a little project. Here’s the deal: I want to create a database where I can add people, and the games owned by those people. After that I wanted to create a form where I could choose x amount of people (either on a … Read moreShow Common Value

Saving the Subform IDs

Hello guys, thanks a lot for helping me out last time. It gave me a totally different perspectives on the further development of my project and I took the new perspective up. But I am facing another problem. I have main form M and a continuous Subform S. S contains list of products that are … Read moreSaving the Subform IDs