Search results for query: *

Hello all. I have a report that calcualtes shipping quantities. i have a cople of fields [NUMBER OF UNITS A] [NUMBER OF UNITS B] AND [NUMBER OF UNITS C]. If there are 0 units, i would like the 0 not to be visable. i cant just delete the 0 because if i do, the calculation at the end screws up and...

Hello All. I have a report that shows on time shipping info. It is grouped first by the [primary reason late]. Then in the detail section, it shows all the orders. When I run the report, it first gives mee all the orders that do not have a [primary reason late] (which are on time) and then...

Hello All, I am setting up a report that will allow me to print a certain number of labels of our customers. i first have a table called [CUSTOMER ADDRESS]. In this table, i have the fields "Customer Name" "Address Line 2" "Address Line 3" "City&quot...

Hello all! I have a table where i enter shipping information. in one of the fields [ACTUAL SHIP DATE](format is short date) I would like to make it so only a date that happened in or after the year 2002. is this possible? any help would be appreciated. Thanks!

Hello All! I have a table where shipment tracking information is stored. Some of that information is "MONTH SHIPPED" "YEAR SHIPPED" as well as the "ACTUAL SHIP DATE". Right now i have a query that looks for the particular "MONTH SHIPPED" to give me a...

Hello all. This may seem simple to some, but i have been racking my brain trying to figure this out. i have a table that is called "CUSTOMERS". It includes: COMPANY NAME, COMPANY/DEPARTMENT, BILLING ADDRESS, CITY, STATE/PROVINCE and POSTAL CODE. I have several customers listed in the...

Hello all, I have 2 tables (Shipments_Late_Reasons) & (Shipment Tracking). I have 12 Query's (JANUARY)(FEBRUARY)etc. I then have 12 reports, one for each month. Data is entered into the (Shipments_Tracking) table which include data like, the month an order shipped, specific details about the...

I have a form set up to enter data. As I enter data, certain fields update into a "total" field. Is it possible to have that data transfered from this table to another table using a button witin the form, or either a code within the fields? Any help would be appreciated.

Hello All. I have a line of data in a table that I delete after each use. I enter the data, print a report, then clear the data from the table. is there anyway to do this by either running a macro or module? i would really like to enter the data in a form, print the report from the same form...

Hello all. I open a form to enter data on only one line. then i print a report based on this one line. Is it possible, that when i'm done printing this record, the information is deleted? Because the next time i go into the form to enter data, i only want that line to print. and if if the...

Hello all. I am trying to create a database that allows me to enter address information in either the form screen, or the report screen, then print the selected amount of labels onto the pages. currently i have a databse that has 1 field. then i have a report where the field is on the label...