Search results for query: *

Thanks Chris.... I see now... thanks What's a truck driver worth?? Depends Can or USA? In Calgary Alberta where I am.... typically a starting drivers starts at 10.00 - 12.00$ / hour for local stuff. Long haul... 20 - 36 cents / mile. average 10,000 miles / month. Thanks for the help...

Thanks Chris... Can you further explain the formula abit for me... the 1:1 ??? I've not seen this before.. The formula that I use is a sumif as well but I calulate the 7 day block after sum=<60 then - total to get the overtime. I don't have the exact fomula here but I will get it and post...

Hi all.. I have a payroll spreadsheet that I need help with. I hve the 31 days of the month. What I need to do is caculate every seven days, if the total of the 7 days is greater than 60 hrs, then overtime is calculated. My biggest problem is that these 7 days spill into the next month. IE...

Hi all... I have a querry that selects date: Fee: Other amount: At the bottom of these colums I would like the total of each colum.. I tried a cross tab querry.. but did not get the results I wanted. Any suggestions??? Thanks in advance Lance

Thank you Marie.... thsi exactly what I was looking for... Works great and easy to use... Thank you Thank you Thank you [2thumbsup]

Hi all.... Sorry about the lack of detail about my question... I have one table for the client info and one that has the location of hotel address name, address, phone number...ect.... I thought that if I selected the hotel's name as unique that I could not use it over again... Maybe I'm...

Hi all I'm having a brain fart.... I need to have a refence only box.. IE I have a querry list for address location by I want the address of the location to show as well. Also.... When I run a querry it keeps inputing all 22 addresses. Some record info but with each diffrent address...

Hi Rollie.... Microsoft could not have made the any harder could they.. All I want to start my invoice number at say 5001. I did'nt think that was too tough to do in access. Proven wrong again..... Thanks Lance

Hi all.. I have a dbase for all my cd's for my dj company. Is there a way for access to list all the possilbe titles or artists for say a 3 letter input. IE: if I were to type &quot;TWA&quot; as a artist name... could it come up with Twain Shania or any other possiblies? Thanks in advance Lance

Hi Rollie.. Thanks for the input.... but how could you do this? Or is it there a generic script out there for this? Later Lance

Hi all.. How can I have auto number start at a number that I dictate? Let me know Thnaks Lance

I all.... I've got a dbase that i use as mail list. Now I would like to be able to generate 2 seperate lists from this same dbase. I have a check box that I use to identify the names I would like. But how could I have just the names checked off used as an envople lable.

Hi Chrissie1: Thanks for the info... I'll take a look at the Datediff function....Like to have your input later on.....

Hi all.... I would like to know if there is a simple solution to my probelm.... What would the eaiest way to have a Dbase calculate back 7 days IE Sunday to Sunday and calculate if a person would recieve overtime in this seven days.... Overtime is anything after 60 hrs worked in the 7 day...

Hi all... need some advice.. I have a form and with the dates that employees have taken a course... now I want to have another box show when this employees course is up for renewal... say 3 years from the date taken... Make sence..... I hope so... Thanks in advance Lance

Thanks all

Hi all... I'm kinda new to the dbase stuff. I can make tables,reports,quirries ect... But I would like to get better and start learning SQL. I seams that you can do more this way. What's the best, quickest and eaiest way to learn this? I don't have a whole lot of time to spend on this so...

I've got my table <table1> done... The forms I need done... Now I just need a quirre that asks for a client's name and reports back all or some the sales done with this client... I've got a quirre started that prompts for the name.. but will not pull the data I need... IE. last date shipped...

thanks all.... I'll try these and see...

Hi all.... I have spread sheet for my payroll for my drivers.. across the top I have 1- 31 for a date.. down the side i have the drives names... what I would like to do is be able to sum the total (already done) then take everything more than 10 hours and add this for the over time...