Search results

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...

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...

Using the Northwind sample database, what is the best way to run an update query that updates the UnitsInStock field based on what has been sold? That is the table is updated based on a particular orderid and only on that orderid. Running an update query at the moment updates the table on all...