Recent content by luvphx09

  1. L

    IIF statement question

    The error is that the calculation doesn't show up. It just says #Error inside the Field I am trying to get the calculation to work. There is no error number.
  2. L

    IIF statement question

    I am trying to use this expression and run into a :banghead: =Iif([Craft]="CraftName",[Field1]+[Field2]+[Field3],0) I keep getting an error. What I am trying to do is when a specific craft is named, I want it to had Field1, Field2, and Field3 to get a total. Any help is greatly...
  3. L

    Main Report and Subreports

    Ok, next problem. I thought I had all my subreports bring back a summary. For instance, one of my reports should summarize each craft, total the row and on the bottom show a grand total. Instead the subreport is going day by day and showing each craft total for each day. I would need a full...
  4. L

    Main Report and Subreports

    I have uploaded the file. Thanks for any help you can give me. The report I am trying to print is labelled rInvoice. Thank you.
  5. L

    Main Report and Subreports

    I am still having problems. I think I need step by step instructions. I just cant get it to work. My sub-reports keep pulling data by day instead of grouping them together to show the totals for each prompt I enter for a whole week.
  6. L

    Main Report and Subreports

    I am trying to print one report with the sub-reports included. I would like the sub-reports to bring back data within the same date range as the main report without having to key the date in several times.
  7. L

    Main Report and Subreports

    Good morning. I have a one main report and 3 sub-reports. I need help with figuring out how to get the 3 sub-reports to load the information I need without having to put my date in a million times to see my report. I have tried making a form to supply the Start Date and End Date, and i have...
  8. L

    New to Help Center

    Good morning, my name is Jen. I am new to this forum and looking for help with my database. I am not a programmer but am not new to Access. :D
Top Bottom