Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Matsta
  • Content: Threads
  • Order by date
  1. Matsta

    calculation possibly in expression builder

    In access repots I want Field A to populate with Field b*Field c if field d = yes and Field e = yes. And If field D and Field E are not yes I would like to see zero dollars. Example below: Field B 50 Field C $1.00 Field D YES Field E YES Result I need: Field A $50.00
  2. Matsta

    delete empty fields

    How can you tell if a field is empty and if it is empty how can you program to delete it.
  3. Matsta

    Sql count distinct funtion

    I'm new to SQL and I need to count a unique record in the field. I tried.. select count (distinct ' ') as but it didn't work the way I wanted it to. Dbase example: idnumb 88888 88888 88888 44444 44444 I need these results: 88888 3 44444 2 I know this is really easy..but...

Part and Inventory Search

Back
Top