Search results

I'm altering a database to have certain fields be recorded monthly. For example: instead of a client's file having "Total X Purchased" it would now be "Total X Purchased - Jan", "Total X Purchaed - Feb". I want to spin the monthlies out of the master clients table & in to ex. tbl_clientsJan...

I'm working on a database of client info. The table houses info. on individual clients over the course of our serving them (name, marketing info. [youth, senior, etc.], which services they purchased, % satisfaction with service, etc.) What my boss wants is to be able to compare a snapshot of...

I need to move data in a table to tables in new databases for archiving; & being able to click a button & have the data append & delete is my goal. I made a test database to work on the code. I'm an Access beginner & so go easy: This code creates the archive & runs ArchiveTables (below) when I...

In my database, I have a Table for our clients (tbl_Clients) & how long they were active with our service (StartDate, EndDate), with each client tethered to an ID. My dilemma is: what if a client reactivates? I want to avoid redundant records, & instead detail additional StartDates & EndDates...

So: I have a Report (rpt_ServiceRequirement) which lists clients (from my Table tbl_Clients) & some variables re: those clients, which I've built into tbl_Clients as a Lookup & Relationship (where I've entered the values myself; there will only ever be a choice between a few static options). My...

I'm a long-time lurker. I've used existing threads (& their solutions) for my own database projects; however: recently, I have elected to build small databases for work, & am interested in learning more about MS Access features. I've done some online training, but it hasn't been adequate to...

Hello! I apologize if my title is indecipherable; I'm (relatively) new to Access & am uncertain re: how to accurately qualify my dilemma. I'm building a simple database at work; it contains 1 main Table (tbl_Clients) & another, (tbl_Employees) that are related by "EmployeeName" in both. My...