Search results for query: *

So I want to go through two columns, one with store numbers and the other with SKU's and create a third column that shows every possible combination of the two other columns. EX: Store # | SKU # | Concat | ------------------------------ ABC | 123 | ABC*123 | DEF | 234 |...

If I want to change a field name in a table, is there some way to change all the references back to that table's field name in the rest of the database (forms, reports, queries, etc)? We are currently tracking license payment dates by one field ([Renewal Date]). However, the payment date /...

I currently have three very large spreadsheets to import into Access. Unfortunately, the database I'm using requires two columns to work. Currently the table looks as follows: SKU1 | SKU2 | SKU3 Store # (Quantity) | (Quantity) | (Quantitiy) What I would like to do is...

My position deals with the processing of multitudes of state and county business license applications on a yearly basis. To ease this, we're working on recreating applications in Access97 database reports wherein an image of the application (scanned or copied straight from a pdf file) serves as...

I have a table that stores our gross sales per month. There are two fields - The first is the date that the gross sales were recorded stored as a date/time field formatted "mm/yyyy". The other field is the gross sales field (currency). The problem that I am having is with the...

Recently, I was able to finish my database. It works without any (obvious) bugs. But for some reason, the thing looks like it was slapped together by a 6 year old (or the autoformat function). Are there any websites with some suggestions on how to make a functional database look like it was...

I'm using a database to run the yearly budget for a large chain of stores. To do this we have to figure in stores that will open or close in the future removing the recurring costs for those stores that will close and figuring in other costs for those that will open. This requires that I...