Search results

Hi I have a form which records calibration data on equipment & when it is due. In the form I have a field called calibration Intervals with a figure in months when calibration is due for each equipment item. E.g. 12 months. I have a subform on this form which records all the calibration details...

Thanks Neil & Col this is good info. Rgds

Hi, I am starting to design a Quoting database and would like some advice on how to set up my tables. I would like to record all quotes received with all relating sales, purchasing and despatch/invoice details included. I am thinking of having following tables – Am I on the right track ...

Thanks Bob that works perfectly. Rgds

No worries bob, Tks for your help. Sorry but this still give me same error message. Could it be because F38 has a formular in it. I have attached a sample so you can see waht I am doing wrong. Tks

Tks Bob, When I enter this formular in excel the formular stays visible. Formular does not work in excel. Is this for excel or only for Access ??? Or is it that I don't know what I am doing ? Tks

Bob tks for quick reply. Yes this works if there is a value in F38 But if there is no value at all in F38 I get error message. What I am doing is a Quote template which does not have a value in the feild to start off with. So I don't want this error message appearing. Is it possible ??

Hi, I have an IF formular which looks at a feild & if it is greater than Zero multiplies the value by 10% but if it is zero (no value) I would like the feild to be blank or a Zero to appear. =IF(F38>0,F38*0.1,"0") My formular is giving me a #Value! error when value is zero. What am I doing wrong...

Hope someone can help with this. I have a form which lists all my outstanding orders. Via a Dcount I get a figure of whats in stock for each order (product description & length) & this figure is listed against each parrticular order.(stock Qty) But what I also want it to do is look at the Qty...

Sorry about multiple posts my computer is playing up.

Dave, How stupid of me. And I spent hours trying to figure it out. And thanks for the requery tip. Thanks again Roc

Dave, How stupid of me. And I spent hours trying to figure it out. And thanks for the requery tip. Thanks again Roc

Dave, How stupid of me. And I spent hours trying to figure it out. And thanks for the requery tip. Thanks again Roc

Hope someone can help me with this as I am not sure where I am going wrong. I have two combo box's on a form which are linked to a query which when run SHOULD (this is my problem) populate a subform I have set up on same form. If I run suborm or query on its own it works OK but I cannot get it...

I have a query with below formular which return's all records between Sunday and Saturday Between Date()-Weekday(Date())+1 And Date()-Weekday(Date())+7 I can get this formular to work when it is looking at one date feild. (Date Received). I would also like it to look at the (date completed)...

OK thanks Gemma

Thanks Rak for your help this does the trick , but is there not a less messy way around this. Why can't I change property to date/time for this feild in the query window in 97 or am I doing it wrong ? Thanks

Hi, can anyone advise where I am going wrong with attached query. I just want the waiting time between two sets of time but I don't seem to be able to get the right figures. I have tried to change the property of the query variable by going into the feild properties for the calculated feild but...

Thanks this site should help me. Rgds

Hi I am looking for a formula for my query which filters out only the orders raised in the current week.(5day week Monday to Friday) I did not want to enter dates manualy. Can this be done ? Can anyone help me with this. Tks