Search results for query: *

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

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

In the Query Design , Click on the "QUERY" tab and select "MAKE TABLE QUERY" , run the query and you have the Table

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...

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

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 ???

Thanks Leigh, but does this takin into consideration weekends ??? I need a count of WORK DAYS only . . . Thanks for the quick response though Mick

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

Hi Randy, Worked a treat , Thanks a lot

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 ???

Sounds "EASY" , I'll give it a go Thanks for the advice

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

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 ?

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 . . .

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 . . .

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

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

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