Go Back   Access World Forums > Apps and Windows > Excel

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-08-2019, 12:21 AM   #1
mohamedmatter
Newly Registered User
 
Join Date: Oct 2015
Posts: 76
Thanks: 20
Thanked 0 Times in 0 Posts
mohamedmatter is on a distinguished road
auto number with duplicate -first-last bench

hello group
i attach sample schooldb
my request
1- Id-School without duplicate Id
2-Id-School duplicate Id to school
3-First bench and First bench in all school

many thanks
Attached Files
File Type: xlsx SchoolDb.xlsx (11.3 KB, 5 views)

mohamedmatter is offline   Reply With Quote
Old 05-10-2019, 07:35 AM   #2
mohamedmatter
Newly Registered User
 
Join Date: Oct 2015
Posts: 76
Thanks: 20
Thanked 0 Times in 0 Posts
mohamedmatter is on a distinguished road
Re: auto number with duplicate -first-last bench

Does the question need clarification?
mohamedmatter is offline   Reply With Quote
Old 05-16-2019, 08:35 PM   #3
mohamedmatter
Newly Registered User
 
Join Date: Oct 2015
Posts: 76
Thanks: 20
Thanked 0 Times in 0 Posts
mohamedmatter is on a distinguished road
Re: modified auto number with duplicate -first-last bench

i draw lines to request
Attached Files
File Type: xlsx SchoolDb-v2.xlsx (20.7 KB, 1 views)

mohamedmatter is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto number, year, month number combination nrgbmwx5 Tables 10 11-20-2015 08:26 AM
Auto Number PK, change starting number? Ms Kathy General 7 12-29-2013 09:18 AM
Appending Records with a desired auto number in a table with Auto Number El hombre Loco Tables 7 10-21-2013 11:13 AM
Auto increasing a number, depending on maximum number when condition is met dannewestis General 3 09-22-2006 10:00 AM
Query that result incremental number, with no Auto-Number alvaro_xav Queries 1 09-11-2006 07:51 AM




All times are GMT -8. The time now is 04:30 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World