Search results

I am linking the report to a query. The query currently pulls based on the "DATESOLD" field being null, meaning the vehicle is still in stock. This works fine, and pulls all the vehicles properly. Now I just need to sort them by the LAST 2 digits of the 4 digit stock number. I see your...

Not sure what you mean, if i create a query using that, i get no items Do i put that in the query? I am not sure what you mean by "make a new column" ?

Hi, we have a database that uses stock numbers. They are 4 digits, for example 5298. They increment every time we add a new vehicle to stock. I need to print a report, but sort the vehicles by the LAST 2 numbers. In other words, if there are 2 vehicles, for example, 5225, and 5325, i want...

Thanks for the great tips Neil, only one last hurtle! I now have the value showing up properly in a text box on the main form. All I need to do now is store this value in the field "totalacv" PERMANENTLY, anytime a new "reconditioning" item is added to the subform. I can't seem to get this to...

Thanks guys, got it up and halfway working, subform now shows reconditioning done per stock number. Now, how can I get the subtotal of the "reconditioning" from the subform TO the main form to calculate my ACV? I have tried using the example in ACCESS help, but it keeps showing me #ERROR in...

Hi all! Here is what I want to do, and what I have done so far: I have one table called "AUTOS" This is a table imported from pc file, and tweaked to make it work well in Access. I learned alot doing this, and now have workable forms, queries, and reports being generated on this table. I...

Thanks for the replys! I actually just got back to read this, but the solution was what pat recommended, I was just having a hard time wrapping my mind around the solution. I am new to access programming, so while there is a somewhat steep learning curve, it seems to offer alot of information...

I am using Access 2000, and am trying to query our table to get what we call a "Prior inventory Report" We are a used car dealer. On this report we will need to pull data based on 2 criteria: Every vehicle that was in stock up to the date entered in the report. To do this I am using a query...