Recent content by jimbo89

Thanks Fuga, I probably should have known to use a payments table linked to the members table.....memory lapse. I'll do that and try some variations for updating when required. Thanks again for your response.

On a membership Db, I want to keep track of which members have paid their fees for the year. That bit's easy but on the 1st of January, I want the FeesPaid field to clear, the fieldname to add 1 year ie [2010feespaid] = [2011feespaid] ready for new input, and the 2010 data ie clubname to...

I probably wasn't clear with my last post about NWind. I am using it to learn only. What I actually want is from the dialog form, to select members from a particular or all ex-military service/s (Country in NWind), then narrow it down to a particular or all suburb/s (City in NWind). So the end...

Hey everyone, the customer labels dialog form in Northwind is what i'm playing with and I want to add a 2nd option group. The current one allows to select 'all countries' or 'specific country'. I want to add 'all cities' or 'specific city' in the 2nd group. What changes need to be made to the...

Thanks to everyone that has responded to this qyuestion, I have taken it all on board and tried all of the suggestions. There are a few things that are still confusing me but I will work through them. I have downloaded the time/billing db and will look that over to see what is relevant to my db...

Thanks for the example Michael, I doi indeed see it now. But that means each product has to be entered 3 times (in my case), once each for each price level. I was hoping and iif function could be performed on the products table using the customer's criteria but oh well. Thanks again Jim

Until I asked this question, I considered myself to be at the intermediate level of access knowledge. I will now modify that to extreme beginner.....I am totally confused and think maybe I am not explaining myself too well. Each Product has 3 levels of price eg PriceLevel1 = $1.00; Level2 =...

Forgot to add that I have also added the IIF statement to the criteria of the existing 'UnitPrice' field in the ODE query. Thanks

Aaargh, it's not working. Using the Northwind Sample Database as the example, which I am, I have added a field to the 'Customers' table (PriceLevel) and 3 fields to the 'Products' table (PriceLevel1;PriceLevel2;PriceLevel3). The Order Details Extended qyuery works the Orders Subform where the...

Thanks again. I thought the IIf statement was the way to go, I remember doing something similar many years ago on Access95 but it totally left me. Great help, thanks again. Jim:)

I think I preferred the IIf statement. At least I understood that. The customers table has a field called PriceLevel with 3 choices. The Products Table has 3 fields - PriceLevel1 (CostPrice), PriceLevel2(some products marked up) and PriceLevel3(All products marked up). The Orders query that...

Thanks Michael, I assume this goes in the criteria section of the query. Right? Jim

I have a customers table where the customers are assigned a price level. The products table has 3 levels of sale price. How do I write the query to make the unitprice = Products.PriceLevel(1,2,or3) based on Customers.PriceLevel(1,2,or3). That is if Customer 1 has been assigned PriceLevel 1...

Thanks RG, sounds good

I've checked Allen's code and it certainly looks like what I want. Where does it actually go ie afterupdate/beforeupdate on a certain form? Thanks again Jim