Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Position number for a location

Position number for a location

Position number for a location

HI, I'm in IT support and my user has a db that has a checkbox field listing several local areas; eg. Sunnydale, Mount Shining, Timbuktoo etc..  When the user enters a new record and selects say Timbuktoo, user wants to show on screen this is the 23 Timbuktoo entry.  Basically, If("area"="Timbuktoo",TRUE value Timbuktoo serial no. 123,FALSE value Other location serial no. 234).  Basically, user selects Timbuktoo and the number 23 appears for the 23rd Timbuktoo Entry.  If user selects Sunnydale, would like it to say 15 if it is the 15th Sunnydale entry.

So far, I have created a Timbuktoo & Sunnydale dbs & joined it to the "Area" field.  Have created an auto-serial no. field in Timbuktoo db but am unable to get the "position" number.  Have also tried "position" formula in creation field unsure how this really works but I got zero as the result.  Had a look at some enquiries herein, but couldn't find anything.  Any help very much appreciated.  Rgds Mik

Any help would be appreciated.

RE: Position number for a location

This one is a little complicated to explain in a forum like this. And I think we answered you in great detail on XpertSS.com recently.

Basically, you need to create an alias of your database and join it to the original on the "Area" field. Then add a repeating panel of the alias database to your form. Define a calculated field = SCount(aliasareafield) with summary option of "All records in xxxx" where xxxx is the alias of your database. You can now use the calculated field to show the number of entries for a given area. Substitute your db and field names!

Note that the calculated field number will not increment to include the new record until you press ENTER to commit the new record to the database.

Sue Sloan

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close