Search results

  1. J

    Auto Numbers In a Form wont show format from Table

    I have seemed to figure this out. I was gong about it all wrong. Thank you guys! You were all a big help! :)
  2. J

    Auto Numbers In a Form wont show format from Table

    I did that at it just changes it on me to: "=R "&" Form"a"t(ID"," 000) "&" 08"
  3. J

    Format Control on Auto Numbers

    So, if i want this non auto number to auto populate when i create a new record in my database how do i do that?
  4. J

    Auto Numbers In a Form wont show format from Table

    I have a table with an auto number and its format is: \R000"08" My goal was to have an auto number where it looks like R00108 and only the 3 digits between the R and the 08 change. The above format enabled me to do so. THe problem is that in the Form i am making, it will only show the...
  5. J

    Format Control on Auto Numbers

    I am making a tablethat will require an auto numebr, but i need it to generate in my format: R00108 R00208 R00308 R00408 As yo can see the number that changes will be the 3 digits between the R and the 08. How can i do this? I am not too farmiliar with this stuff so forgive me if my...
  6. J

    Can you use IF formulas?

    I may be confusing you. I have about 15 querys that I use as the source of a mailing database. The different querys have different criteria that make them apart of that query, and the querys update daily. For each query i have a word document that is different. Instead of having to open all 15...
  7. J

    Can you use IF formulas?

    How do I do that? Should I make a new table, or query? I guess I just don't know the steps involved in doing that. Thanks!
  8. J

    Can you use IF formulas?

    I am trying to make a table or a query that auto fills in if another table or query has met a certian criteria. Basically here is my set up: Query 1: has a check mark in a given cell, or it says YES. Table/query 2: I want a given cell to say Yes, or auto populate a checkmark, because...
Back
Top Bottom