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!

  • Congratulations TouchToneTommy 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. lancemeroniuk

    PAYROLL ON EXCEL

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

    sum to totals

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

    HELP... BRAIN FART!!!

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

    searching a dbase

    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 "TWA" as a artist name... could it come up with Twain Shania or any other possiblies? Thanks in advance Lance
  5. lancemeroniuk

    auto number

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

    MAIL LISTS TO SEPERATE

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

    payroll issues

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

    how to show future dates

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

    SQL

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

    quirries>>> ugg!!

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

    excell fomula

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

    adding a total

    Hi all.. just setting up my dbase for a trucking company question.. on my form I have a total box... In my quirre I can get the figures to add together.. now I need to show this total in the form. Any suggestions yould be helpful.. Thanks

Part and Inventory Search

Back
Top