Recent content by alan1203

Thanks to both of you for your time.

Thanks guys, here is the SQL SELECT tblParts.PartDescription, tblParts.PartNumber, tblParts.Price, tblParts.Drawer, tblParts.Compartment, Sum(tblUsedRecd.Received) AS SumOfReceived, Sum(tblUsedRecd.Used) AS SumOfUsed, [SumOfReceived]-[SumOfUsed] AS Expr1, tblParts.[Do Not Re-order]...

Hi, I have a simple Access query that Sums the number of items received and the number of items used, then uses an expression to calculate 'Received' - 'Used'. The table that contains this data just has 'Date', 'PartNumber', 'Received', 'Used', 'OrderNumber' and 'Comments' fields. I populate...

Thanks Skip. How would I use a reference for a date?

Thanks Skip. How would I use a reference for a date?

Thanks Skip. How would I use a reference for a date?

Thanks Skip that works a treat. What a good function that is. Thanks also to Combo for your reply. I was thinking that there was something wrong with the way I was referencing dates. I'll keep that in mind for the future.

I have a spreadsheet with outstanding repair / maintenance jobs. I have been asked to break that down into jobs that are > than 3 months old and then break them down into Yearly stats. I think i have the greater than 3 months jobs sorted with =IF(AND(PlannedDate <> "",PlannedDate <...

The code you gave me works fine with the one line that I asked for and i was thinking about just copying that code for each line in the list but the list I have could grow in the future and I was hoping to avoid having to go back into the VBA editor each time as i've no clue what i'm doing. I...

Thank you PHV. If I was wanting to do the same for other rows can I just copy this and edit the ranges? or is there another way of doing this? Thanks

Sorry for the repeat post but my interpretation of Johns second post in my office thread was that my problam would best be solved using VBA and that I should post another thread in this forum. Could you be kind enough to offer anymore advice on this? Thanks, Alan

Hi I was hoping somebody can provide me with an easy was of updating a date in an excel cell if I change any cells in a range in a worksheet. For example; If I change any of the data in range "A2:G2" then the date in "H2" will update to todays date. Thanks Alan

Is there an easy way of entering the date in a cell if any of the cells in a range are changed? For example If any of the cells in range A2:G2 are changed then H2 = the date that the cells were updated. Hope this makes sense. Thanks, Alan

Solved it. I had to put the If argument into a macro and run the macro on exiting the field and it works no problem.

Hi, I have a form created in MS Word 2003 and one of the fields is for a price. I was hoping to have a message box if the price was greater than £5000. The form field bookmark name is "Price". I've tried If ActiveDocument.FormFields ("Price").Result > 5000 Then... as a general decleration in...