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
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?
I’ve just inherited a team who run a lot of their work through an Access DB. I don’t have any experience at all with Access, and I know a tiny bit about SQL but I’m a total beginner. I don’t understand how to find the SQL server that Access is importing some tables from. There … Read moreUnpicking an Inherited DB… Help!
Create a query using the tblCustomer table. Display CustomerID, FirstName, LastName, and a new calculated field named Coupon?, in that order. In the Coupon? field, use the IIf and Like functions to display No Coupon if the customer did not take the tour and Send 10% off next visit if the customer did take the … Read moreNeed help with MS Access Homework -IIf and ‘Like’
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
I’m still pretty uneducated with Access, and it’s been over 10 years since I took anything formal with it, but I’m really hoping to get some help in a couple directions. Background: We use an Access DB for our Inventory at work. It’s VERY basic, and is a glorified Spreadsheet, but it allowed me to … Read moreRun Multiple Queries(report?) for different values
Hey guys, This is very weird and might sound like a joke but I’m dead serious. I have a table with data and each record has 3 fields that are blank. The table is connected to a Form and the user is supposed input the missing information in the form which then updates this table. … Read moreAppend query appends only part of the data
Hi all, I’m trying to build my access database where i’m tracking emails sent to users using mail merge, with a first template and 2 reminders to reply to this email. My table is has 4 columns which are all dates: 1. Username 2. When the first email was sent(mail1), 3. when the reminder was … Read moreQuery to update the results of another query
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
Hello! I once again can’t seem to find the right answer via google, and I’m not sure if this can be done. I have a form that has several sub forms etc. All of these are linked based on the EmployeeID that is currently selected for the main form, which is linked to the main … Read moreAdding record to table via combobox and button