Search results

Let me preface by saying that my manager is keen on using Access for this project and very much against using Excel other than for inputs/outputs. Below is my thought process for my database. It would be a huge help if you guys could identify any red flags you see with what I am aiming to...

I currently have a table called “Payment History.” Though there are numerous fields, my question only pertains to two particular ones LineID and PoID (representing Line ID and Purchase Order ID respectively). There is a one-to-many relationship between these two fields (i.e. a single purchase...

Right, using a form now makes sense. In regards to the actual form design, can you elaborate on the Master/Child Link Fields. What table would the information then be input into to?

My question regards 'linking' two tables (i.e. clicking on a value in one table will bring you to that same value in another table). Here is a summary of what I have and what I want to do: Table 1: Purchase Orders -This table gives information about a respective purchase order (PO) with each...

Bingo! I'm going to play around with the query to get quarterly totals. The problem was actually the name of the given table--I mistakenly typed the fields with spaces, but I figured it out. Thanks Steve! -dl1727

Hmmm I keep getting the following error: "The Microsoft Office Access database engine cannot find the input table or query 'Purchase Orders'. Make sure it exists and that its name is spelled correctly"... For clarity, my field headings in my "Payments Received" table are: Purchase Orders...

I definitely agree that queries are the way to go. Here's a simplified version of what I am doing and then maybe you can direct me how to generate a query that gives cumulative figures: I am entering Purchase Orders into a database, so PO# is my unique key. For simplicity, the next field is...

Hi Steve, I appreciate your rapid response! I am absolutely open to a revamp of the database format. I am pretty set on using a database for this project (instead of using Excel). What would you suggest instead? Thanks, dL

I have two tables: Payments by Month and Payments by Quarter. The 'Payments by Month' Table has fields that indicate how much of a given payment was received in a certain month (i.e. 12 fields). The 'Payments by Quarter' likewise has similar information, however reduced to only quarters (i.e. 4...