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 Mike Lewis 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. MsJami

    Custom toolbar

    That was easy I tried everything but that. Thank you Jami
  2. MsJami

    back door bbd

    O.k I am going to do all those things when I get home from work. Thanks alot and I will keep you posted Jami
  3. MsJami

    back door bbd

    I have this thing that pops on my computer all the time from Mcaffee which is trying tp block it out. It is back door bbd. But I can't get rid of it. It effect win32. I am at my wits end can someone please help. Jami
  4. MsJami

    Custom toolbar

    I created a custom toolbar and now I want to get rid of one of the buttons. I can't find where to do this at. Can someone please help thanx Jami
  5. MsJami

    Multiple subreports

    OOps I have also have a table that lists all the subs and that is actually the main form then the three would follow they also have a subid. Jami
  6. MsJami

    Multiple subreports

    Hi, I have 3 tables all linked by subcontractid, subcontracts is my main table, subchangeorders is another and subinvoices is another. I want to have a form with these three tables as subforms. But I can only do subcontracts and subchangeorders, or subcontracts and subinvoices. Any suggestions...
  7. MsJami

    Base a report on excel

    Thank you very much sir Jami
  8. MsJami

    Base a report on excel

    I am ignorant at this so bear with me. So link my Contracts table to my excel spreadsheet. or Do I link my excel spreadsheet to my contracts table Thanks again
  9. MsJami

    Base a report on excel

    This is just a question to see if it is possible. Is there a way to base a report on an excel spreadsheet, or do I have to import the info into a new table. Thanx Jami
  10. MsJami

    Hiding duplicates

    I have tried that and everything else, when I put a filter in my report it works then the rest of the information doesn't show up. I will keep plugging along. Any more help would be greatly appreciated Thanx Jami
  11. MsJami

    Hiding duplicates

    Sorry about that, here goes Employee Job# HoursBreakdown Totalhrs Subsistence John 518 5 8 none 520 3 Jack 500 8 8 none Donald 500 8 8 none this is how...
  12. MsJami

    Hiding duplicates

    O.k. My report has employee, job#, hourly breakdown, total hrs, subsistence the employee total hrs is fine and so is subsistence. their might be more than one job# for each employee for that day with different hours for each location. If any employee only worked at one job I just want the...
  13. MsJami

    Hiding duplicates

    I have a report that is a daily time sheet most of the time the guys work at only one location. But when they work at multiple locations I want to only display the hourly breakdown for those with more than one location. At the present time everbodies hourly breakdown shows up I only want the...
  14. MsJami

    Sum function in Subreport

    Nope no success. I even tried different subreports separtley and still nothing. I am going to try something totaly different if it works I will let you know. Thanks for your patience Jami
  15. MsJami

    Sum function in Subreport

    One more thing my report is called subcontracts but the record source for that report is a query called subsrecap. I don't know if that makes any difference. Jami
  16. MsJami

    Sum function in Subreport

    with the error report =IIf(subcontracts.Report.HasData,subcontracts.Report!SumOfEstimatedCost,0) + IIf([equipment/rentals].Report.HasData,[equipment/rentals].Report!SumOfInvoiceAmount,0)+ IIf([materialrecap].report.hasdata,[materialrecap].report!sumamountspent,0) +...
  17. MsJami

    Sum function in Subreport

    Yes the text box is below in the same section Here is the expression...
  18. MsJami

    SQL book

    Thank I will check it all out Jami
  19. MsJami

    Sum function in Subreport

    Does not work #error is the message. I did it in expression builder I am at my wits end Jami
  20. MsJami

    SQL book

    Hi, I was wondering if someone could give some advice on what would be the best sql book to buy. I know very little and am intrigued by it and want to learn more if anyone can give any suggestions would be greatly appreciated Thanks Jami

Part and Inventory Search

Back
Top