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 Chriss Miller 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: Kosmo2
  • Content: Threads
  • Order by date
  1. Kosmo2

    Remove Blank Spaces in a query

    Hi,I have a database which is based on an EXCEL file import, however I have some fields which have multiple spaces before the data , I would like to remove the spaces in the query and align the data to the left but leave the spaces intact in the table , any Ideas ??? Example (Align all data to...
  2. Kosmo2

    Date Diff

    This Maybe a common question but can anybody give me a line on working out the number of days between 2 work days in a query ?? That is between Monday to Friday on any given date, my fields are :- "Stop Date","Re-Start Date" and number of "Elapsed Days " Thanks Mick
  3. Kosmo2

    Circles in Reports

    Can anybody tell me an easy way to create a circular text box in a report , Basically I need it to display a single letter and have the circle background turn Green, red or yellow depending on the letter entered via a Input Form i.e. R , G or Y
  4. Kosmo2

    Day of the Week in Query

    Can anybody help me with this please :- in a query how do I take a specific date and return another date which is always on the Friday of the same week ?
  5. Kosmo2

    Table Location

    Is there any easy way to find out which queries,forms or reports are using a specific table or tables ?? I want to ensure that if for any reason I delete a table or rename it, it wont mess up my queries . . Thanks
  6. Kosmo2

    Command Button Password

    Hi, I would like to create a Command button (basically a Yes/no Button) on a form that is password protected , essientially when you click on it I want it to ask you for a Password before it will operate . . any Ideas anybody ?? Thanks

Part and Inventory Search

Back
Top