The vendor receives a designated discount. It might be 15%, 50%, 25%. I need to know how to enter a statement in a query that will figure that discount. I.E. Field names are: Cost Rate Per Word AddntlWords Costforaddtnal words Discount Subtotal with discount Total...
I have developed a form based on a query. Each field has appropriate calculations i.e. Cost=[Rateperword]*[Addtnlwords]. I cannot figure out how to calculate a discount rate based on percentage. I also cannot find a reference to how to do this in any of my support books. I should be able to...
Since I was having a dbase problem with the labeling function, I exported each table, query, macro, everything into a new database. The only problem is that the relationships don't show up, even if you add the tables to the relationship window. Everything functions as it should, there is just...
The labels report in my database suddenly won't work. When I pull up a simple report to preview and print labels it comes up with #Name in every field. If I try to create a new label I get the following:
"The function you entered can't be used in this expression. *You may have used a...
Thanks so much, I will try some of these suggestions and get back with you. I don't know how to tell you the table structure. What are my choices? I'm being silly, but serious. I have only been managing this dbase since September, have learned so much, but have so far to go. I am scheduled...
I have created a database based on ads for a newspaper association. I now need to calculate the number of run times based on start date and end date. I am not a programmer per se. I'm new at this, so be gentle. A techie told me to use a get remaining week function using the dim feature. 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.