Unanswered: Access - Username and Chronoloigal Queries
I am creating a database to store part information and pricing history and I have two issues that I cannot seem to solve.
First, I have an import form to import pricing information on a list of parts from Excel into a table in Access. I would like to append the windows user name onto each line of data to mark the person that uploaded that information. I already have code to pull the windows user name, but I cannot figure out how to put it into the table when someone is importing information.
Second, I would like to create a query to pull back information on a part number. My issue is that I cannot figure out how to pull back complete lines from multiple different tables in order to display them chronologically. For example, a part may be entered into the Original Pricing table on 1/1/13, and a discount on that part may be entered on 3/1/13. I want to be able to search for a part number and have it pull back the line that includes the original pricing and a line that includes the discounted pricing. Perhaps this might require creating a new table that combines all tables in order to accomplish this, but I'd like to know if there's an easier way.
For the first, it would help to know what method you use to import the data. For the second, what is your table structure? You seem to be saying each price would be in a different table, which would generally not conform to normalized design.
When analysts price a part initially, they use an excel file to document it. That file will get loaded into the Initial Pricing table. When a regional analyst hears from the region that the price was too high, they make an adjustment, but also log the price review form they received from the region into the Price Review table. I would like to be able to do a search for a part number, and it pull back the part number, description, price and date from each line that part is listed.
Thank you! Now the way that I'm importing these sheets of information requires that the header of the column in Excel match the header of the column on my table. If they don't match, the info won't get imported. Do the columns of data that I want to union have to have the same title?