Search results

I have a query that asks for input from the user (Customer PO number). This is used to create a form where a customer service person can find out what's been ordered, shipped, etc. by the PO number. What I need to do is transfer that information to a report format. Since the input is done in...

I have a report that runs January through December. I need to print all the months whether they have a value in the field or not. I've tried a module and an expression in the control box for the month. I must not have the magic formula. Can anyone help? Thanks, in advance. Beth

The database I'm working on uses numbers for months instead of text. I've had a request to replace the numbers (1-12) with the months (January - December)in reports. I think this is probably a macro function but I'm not sure. Does anyone have any hints??? Thanks, in advance, for your help!

My report is January - December sales trends. I have "quanity", "dollar" and "average" fields that subtotal. How do I get the "average" field to actually do an average of the sum of total "dollars"/total "quanity"? It seems that Excel will not allow me to use formulas a pivot form. Must I go...

I need to do a January - December sales report which will give me quanity sold and dollars sold amounts. It needs to be grouped by material type and I need percentages by quanity sold and by dollars sold for each material type total. Can anyone help? Thanks!

The company I'm working with is doing a physical inventory and needs to print the inventory list (Report) 50 items to a page for reconciliation purposes. Does anyone know how to get Access 97 to print a given number of records to a page? Thanks!