everytime i type it in it says its missing a comma...
=If((Or([SATYPE]="C",[SATYPE]="R"),-1,1)*[# Shipped])
am i missing something. satype is the field name for the types. and i need to multiply it for Qty SHipped and Price.
i'm not sure i understand. I highly customized the report will creating it with ms query keep the same customizations? and then what will i put in the edit/date range paramaters if type c make negative?
or if its easier the report is made off of a table. if there is an easier way of writing something to go through the table and set the values to negatives in the table before the report is even run that would work as well.
I have a report that i run every morning. The report breaksdown the sales for the day by username and type of sale. each sale can also be either an order,type O, credit, type C, or return, type R. I need to add some VBA to the report that when a line is a type C or type R the qty shipped and...
I figured out the problem. I deleted my default printer because we got a new one. and for some reason access didn't pick up that i changed default printers. So if anyone is getting rid of they're default printer...change default to a new printer before just removing the printer. Now that i've...
Every morning i run a macro that runs a series of queries to build tables for some reports that i made. For some reason this morning i come in and i ran the macro, checked to make sure the tables were built, and then went to open the report and its not opening. it just give me an hour glass...
i am wiring a small business network. i did all the jacks using B wiring. i am now punching down to the patch panel. I am punching the patch panel type B like i should. when i plug the tester in i continue to get pairs 3-6 and 7-8 switched. Any ideas? i know both ends are punched down...
its not coming from a centralized access database. it comes from an AS400 system . the access db uses linked tables to the AS400. how do you use linked front end?
Recently my boss asked me to purchase Office PRo for him so he could use Access. I am the network admin here and i dont want him having access to many of the queries because they are directly linked to our system and could completely ruin all of our data if a query is run incorrectly. he has no...
I am wondering if anyone knows if it is possible to write VBA to automatically every morning run a macro and then email a report that is built by the macro to a specific email address. I'm pretty sure that can be done but the trick comes here...in the macro 2 text boxes pop up asking for a from...
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.