Associate
For those who have helped me so far, very mant thanks.
Am now nearing the end of my epic battle with acces and now only have 2 snags i ned a bit of help with.
The first involves criteria for queries. I need to be able to run 2 queries and generate reports from them tht will show all clients seen within the last week (query 1) and all clients seen in the last month (query 2). I reckon it will have something to do with the Date() function, but cant seem to figure out how to 'word' it correctly.
The second snag i think may be a relationship problem. When someone orders an item, you select the price from a combo box. Someone will then leave a deposit. I have a text box that shows the outstanding amount. This was done with 2 AfterUpdate events. The first on the price combo, which puts the price into the outstanding amount box, and the secon on the deposit amount combo, which then subtracts the deposit. It all appears to work correct (ie values are placed and the maths side happens) it is just that when you select the price, the AutoNumber that goes with the price combo is placed in there, not the actual price.
Any ideas or help on the above will be happily and gratefully received.
Cheers all for getting this far and for nay help received
Paul
Am now nearing the end of my epic battle with acces and now only have 2 snags i ned a bit of help with.
The first involves criteria for queries. I need to be able to run 2 queries and generate reports from them tht will show all clients seen within the last week (query 1) and all clients seen in the last month (query 2). I reckon it will have something to do with the Date() function, but cant seem to figure out how to 'word' it correctly.
The second snag i think may be a relationship problem. When someone orders an item, you select the price from a combo box. Someone will then leave a deposit. I have a text box that shows the outstanding amount. This was done with 2 AfterUpdate events. The first on the price combo, which puts the price into the outstanding amount box, and the secon on the deposit amount combo, which then subtracts the deposit. It all appears to work correct (ie values are placed and the maths side happens) it is just that when you select the price, the AutoNumber that goes with the price combo is placed in there, not the actual price.
Any ideas or help on the above will be happily and gratefully received.
Cheers all for getting this far and for nay help received
Paul