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: *

  1. Kosmo2

    Remove Blank Spaces in a query

    Your Correct Duane aand it works perfectly , Thanks , thanks also to Golom, this is usefull for another task I have Mick
  2. Kosmo2

    Remove Blank Spaces in a query

    This wont modify the data im my table will it ?? I need that to stay intact
  3. Kosmo2

    convert query results to table

    In the Query Design , Click on the "QUERY" tab and select "MAKE TABLE QUERY" , run the query and you have the Table
  4. 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...
  5. Kosmo2

    Date Diff

    Thanks Bob , this looks interesting , I think it will suit me fine , YA I guess your right "If it's Access, it ain't easy" , I figured it was a common question and something simple which MS built into Access , I guess I was wrong :-) Thanks to everybody who gave a reply Mick
  6. Kosmo2

    Date Diff

    thanks Les, that looks good , however its a little more complex than I envisioned , do you know if there is any quick and easy equation which I can simply use as an arguement within my query without creating new tables and complex things ???
  7. Kosmo2

    Date Diff

    Thanks Leigh, but does this takin into consideration weekends ??? I need a count of WORK DAYS only . . . Thanks for the quick response though Mick
  8. 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
  9. Kosmo2

    Circles in Reports

    Hi Randy, Worked a treat , Thanks a lot
  10. Kosmo2

    Circles in Reports

    Thanks for the info Randy, however this code is to create a Pie chart type circle in the report , I am sure for Access Wiz's it is easy to modify but to your average user it doesnt suit , how would you Modify the code to show just a solid colour ???
  11. Kosmo2

    Circles in Reports

    Sounds "EASY" , I'll give it a go Thanks for the advice
  12. 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
  13. 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 ?
  14. Kosmo2

    Table Location

    Thanks for the link Steve , Speed ferret certinly fits the bill but $200 is kinda steep , I was figuring on shareware or something in that line . . .
  15. Kosmo2

    Table Location

    Thanks for the link Steve , Speed ferret certinly fits the bill but $200 is kinda steep , I was figuring on shareware or something in that line . . .
  16. 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
  17. Kosmo2

    Command Button Password

    Hi Steve, Thanks for the response , Actually I am a complete newbie at Access and was looking for help with the actual code for the event to do this operation . . . anywhere you can point me would be helpfull Thanks
  18. 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