Actually, I've found the easiest way to do the same report for a range of objects (in this case people) is to just do a main report, then group by the identifier for each individual (say social security number or whatever field you're using for a key), then set up a subreport (this will be the...
If you don't have any page width limitations, you could always just click on the grey square at the top of the row numbers and to the left of the column letters, highlight all, then double click on the column edge.
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 /...
Just in case anyone's still wondering, if you don't mind having a huge form, you can use the graphic select tool in Adobe Acrobat and select the entire document (one page at a time, mind you) then paste that into the design view of your form. After that you can change the size mode to stretch...
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...
How are you formatting your field:
"mm/dd/yy" = 01/01/02
"m/dd/yy" = 1/01/02
"m/d/yy" = 1/1/02
etc...
If you want to search for months by integer (entering a 1 for january as opposed to the full date) then a good way to express that criteria in a query would be...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.