Search results

Once again AWESOME! Thanks pbaldy! You made my day a whole lot easier and more productive. :)

Please look at my edit in my last post. :)

AWESOME! Exactly what I needed! Thank you so much! I was obviously making it much harder than it had to be! :) :) [EDIT] But I've ended up still with a problem, using your sql statement how can I make it so I can put criteria in other columns like in the CertNumber column I would like to...

That column is Era I just found this code on a site and got it to work for one column but am unable to add another totaled column: SELECT A.[ItemDBID], A.[PriceCost], Sum(B.[PriceCost]) AS "running total" FROM ItemDB AS A INNER JOIN ItemDB AS B ON A.[ItemDBID] >= B.[ItemDBID] GROUP BY...

Here is the sql statement I have now. (with changes I thought you meant?) SELECT ItemDBID, Count(*) AS total FROM ItemDB GROUP BY ItemDBID What I would like is for the total column to show a running total, so it would look like this instead of what is there: ItemDBID total 93...

If my table is ItemDB is this how it would read? SELECT "Qty", Count(*) AS "total" FROM "ItemDB" GROUP BY "ItemDBID" Qty and ItemDBID are actual columns in the table, ItemDBID is the autonumber unique primary key. Do I leave the wildcard and put table names and column names in quotes as I have...

I'm not real swift at Access, which will be obvious! I have a data base of items, some items are categorized as Ancient and some are categorized as Spanish. Each item in the table is unique so there are only one of each item. I am trying to create a year end query where I can total the cost...

I appreciate all the help, and I probably should do that to insure there are no further implications from the stuck data. But for the time being I succumbed to it's wishes and went through and changed the code to read "rulerFilter" instead of "RulerFilter"! It is working but I like the idea...

No that didn't cure it??? :( I have completely taken all routines built around the rulerFilter out of the code and "rulerFilter" is still in the object list. I have no such creature on my form or in my db tables? so how can I have an object that doesn't exist anywhere but in the vb code object...

No I haven't done that, but I will now that you have suggested to do so. : :)

I am not really familiar with vb so know your not talking to the whiz kid here. :) I have built a form in Access 2007 and have added some event procedures using the visual basic gui. The problem I'm having is there is a wrongly label function or definition, bear with me, .... at the top of...

thank you :) Thanks again CDrake I was kind of thinking that was going to be the answer! Just wasn't sure. I got a few ideas from someone about using a switch in a query to do what I was trying to do. I think that's going to work. Thank you again for your response,

I am trying to get a column to display a user defined paylevel. (I tried to think of how to make this a seperate table but not sure) if a sales person sold 1 - 3 contracts pay level would = 1; 4 - 7 pay level would = 2 and 8 + pay level would = 3. I want a table column to display the pay level...

Thank you CDrake Thank you DCrake for your suggestion. I am very new to working in Access can you give me an example of how to code the OnCurrent Event of the form to check a for the value in the contract table? :confused:

That worked for the first situation Thank you for that idea, that definitely worked in the first instance in which I needed to do that. Now I have one more where essentially I am trying to do the same thing. I have the same form that the sales rep plugs in the buyers information. name...

I have a form where a sales person enters an installation date, called installDate in the db. I need the date to be formatted into a week number in a different column of the table as well as updating it's on source. I am unsure how to do this. Everything I have tried using the expression builder...