Recent content by sadist

Many thanks Michael and Paul for your help 'Me.Report_number.Value' worked Regards Dermot

Hi, I would appreciate a little guidance on the following: I have a form with a number of fields including ID and Report_number. I have 4 Reports named 1,2,3 and 4, each report uses some or all the form fields and the forms Report_number specifies which report to print that record on. I have...

Update I found this article which is the solution I was looking for so again thank you for your help techonthenet.com/access/queries/max_date.php Dermot

Thanks for your reply Alan, I need to clarify a little further. The two linked tables are 'Order Header' which contains order number, order date, delivery date, supplier details, po gross, nett, tax etc and the 'Line Detail' file contains order number, stock code, quantity ordered, unit of...

Hi What I'm trying to achieve but am finding difficult and would appreciate guidance on is to create a datasheet from 2 odbc linked tables which I will be exporting to Excel. The resulting datasheet will have four columns, 'Purchase Order Number' 'Stock Code' 'Delivery Date' 'Unit Price'. The...

Ya know that place as well, still just learned another step. Again thanks Dermot

Bingo!! Paul your a gent, thanks a mil I'd still like to understand and learn more about how you came up with that and more on SQL so would appreciate a pointer to a good practical course Dermot

Paul thanks for your suggestion but I'm still getting the same unwanted result shown in my example above. Brian unfortunatly my knowledge of SQL is not educated so would appreciate a little more guidance. The following is the code behind my query as it stands, how do I use your suggested code...

Apols left out data type in my reply TProdRef1 is also numerical

Thanks for your reply I have tried your recomendation RunningCount: Val(DCount("printref","TPrint Data Store","TprodRef1 <= " & *)) but the formula automatically reverts to the previous version. An example of the actual data result I am getting from the above expression is: printref TProdRef1...

I'm attempting to do a running count on records in a query and reset the count starting again at 1 for each group of records displayed. Following are my fields and sample date. printref - primary key AutoNumber TProdRef1 - Product reference I do have other fields in the query, 6 in total but...