Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Changing a predesigned query
I am using a vendor supplied access database to upload price sheets into our AS/400. On the query, I need to change the preset quantity to accept alpha instead of numerical data. The query is set up to use the imported excel database and plug the information into a form that is readily...- LYSAMARIE
- Thread
- Replies: 1
- Forum: Microsoft: Access Other topics
-
query not populating table
The following is a query that I am trying to run. It runs without any errors, but the data in the table does not get updated. Any clues as to what I am doing wrong? PARAMETERS PDate DateTime; INSERT INTO [New Pricing] ( ManufacturerCode, Standard_Pack, [Date], Quantity_1, DistCost_1...- LYSAMARIE
- Thread
- Replies: 2
- Forum: Microsoft: Access Other topics
-
I need help importing an excel spreadsheet
I have an excel spreadsheet which I modified and renamed. Everytime I try to import the spreadsheet, I always get the original one even if I click on the modified one. I tried deleting the original spreadsheet, but that didn't work. When I open the modified spreadsheet, the data looks exactly...- LYSAMARIE
- Thread
- Replies: 2
- Forum: Microsoft: Access Other topics
