H hamish New member Local time Today, 05:54 Joined Dec 19, 2008 Messages 7 Dec 19, 2008 #1 i have a form customers,subform rates,subform rate transactions,,, In my rates transaction i dont want duplicate months eg 01/12/08,,,meaning one transaction per month I dont know if this makes sense Attachments Funeral PlanA100.zip Funeral PlanA100.zip 503 KB · Views: 83 Last edited: Dec 23, 2008
i have a form customers,subform rates,subform rate transactions,,, In my rates transaction i dont want duplicate months eg 01/12/08,,,meaning one transaction per month I dont know if this makes sense
H hamish New member Local time Today, 05:54 Joined Dec 19, 2008 Messages 7 Dec 22, 2008 #2 Uncle Gizmo said: What about putting a unique query on the date field this should prevent duplicate dates. Click to expand... Thanks for the answer,,,but how would i do that...i am still new at access.
Uncle Gizmo said: What about putting a unique query on the date field this should prevent duplicate dates. Click to expand... Thanks for the answer,,,but how would i do that...i am still new at access.