Mike- If you fix the syntax, that should give you a total count, but it won't number each row. Is SkidID unique? If so, you might be able to generate the count by adding this to the SELECT clause of the query that's the Record Source for the form:
(SELECT Count(*) FROM ShippingDetail As SD2 WHERE SD2.SkidID <= ShippingDetail.SkidID AND SD2.[so#] = ShippingDetail.[so#]) As RowNum John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Tuesday, November 01, 2005 12:35 PM To: ms_access@yahoogroups.com Subject: RE: [ms_access] AutoNumber for Subform Hi John, Can I use DCOUNT for this on my form? I've created a text box on my form with the following ControlSOurce: =DCount("[Skidid]","SHIPPINGDETAIL","[SO#] = 'forms!shippingdetail!so#'") What this is supposed to do is count the number of "Skidid" entries in the "ShippingDetail" table using the "SO#" from my "Shippingdetail" form as the criteria. Looks good on paper, but doesn't seem to work. -----Original Message----- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Monday, October 31, 2005 6:41 PM To: ms_access@yahoogroups.com Subject: RE: [ms_access] AutoNumber for Subform Mike- This is easy to do in a report - simply add a text box with Control Source set to =1 and the Running Sum property set to Over Group or Over All. If you actually want to generate and save this number in each new record, you'll have to write some code in the form's Before Update event to find the previous high number for the current sales order, add 1, and save it. If these records have some sort of sequence, you can also generate the number by using a subquery to count the number of rows that have a lower sequence. If that doesn't help, need more details... John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Monday, October 31, 2005 9:32 AM To: ms_access@yahoogroups.com Subject: [ms_access] AutoNumber for Subform Hi All, I have a subform that I would like to display a "record Counter" on beginning with "1". This number doesn't need to be stored anywhere, it's strictly for informational purposes. The scenario is this: The main form has fields for "Sales Order Number" and "Ship Date". These are linked to the subform which contains an additional field called "Pallet ID". The purpose is to have a counter that would show on the subform so that the shipping folks can keep track of how many pallets they are loading on a truck. The subform is in "Grid" view. Any suggestions??? Idea's??? As always, any help is greatly appreciated :) ================================== Mike Bisson Manager of IT & Logistics Carthuplas, Inc. V: 207-985-4972 x658 F: 207-985-2105 [EMAIL PROTECTED] http://www.carthuplas.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
