Recent content by shevada123

I have a database and enter claim numbers for each claim received. However, this year 08, I want to change the process and have Access automate the claim numbers. Only one person uses the system at a time. I would like the number to start at DN-08-000 and increase by 1 every time I enter a...

Thank You Sooooo Much!!! It worked like a charm!!! Thanks guys... :D:o

Protecting controls If I choose to allow users to unlock the form to make edits.. how do I set that button up? I am going to try this option. Thanks for your quick response.. Thanks guys. :D

I have a database and I have to enter claim information which consists of claim number, customer name, tires submitted, Supplier and so on. I've noticed that when others are using the form they have mistakenly typed over some of the data on a specific record; altering the data. How can I...

Here is the SQL SELECT [NWarrLog-Tires].[Claim Number], [NWarrLog-Claim Query].[Customer Type], [NWarrLog-Tires].TireID, [NWarrLog-Tires].Serial, [NWarrLog-Tires].TireIssueID, [NWarrLog-Tires].[Adj %], [List Price]*[Adj %] AS [Adjusted Price], [List Price ]*[Adj %]+[FET/Handling] AS...

I have a database where I list prices for products. The prices are based on the type of customer. I have a table that lists Customer Customer Type (can be DD or SH) My other table with is the tire table has the following: TireID ITem Number Description Tire Price Sh Price List PRice If...

Hello, I need help writing a formula in a query I have a database where I need to be able to pull different prices according to type. For example, if it is a SH then I will need it to pull a certain price of an item under the SH level if it is a DD, then I will need to pull a price of the...

I am working on a database and need to create an expression in a query that calculates the following: For the Adjustment Percentage = Adj % I need to take the Remaining Tread - 2 and divide by the Original Tread -2 to calculate the Adjustment Percentage. How can I write this expression in...

This is my first post and would like help with the following: I have a warranty database that I have to create adjustment claims. There a re two pricing structures depending on the customer type. One customer type is SH and the other is DD. I need to create an expression within the query...