Recent content by lAMRITH

  1. L

    Options for Access/Excel report printng - Import Excel as a report or push Db data and print Excel sheet?

    I do not think I ever mentioned I am only talking about printing the top 2 rows of information on the printed report. It will not be used to print full information on the entire form. Just the customer and unit information in the top. So far so good. The linked solution above appears to be...
  2. L

    Options for Access/Excel report printng - Import Excel as a report or push Db data and print Excel sheet?

    I should have probably clarified more in OP. I am not an IT guy, not hired to run the system, no training or anything I am just a former mechanic turned office/admin guy doing what I can to try and streamline our process and save us all time while also providing clearer job tracking. I am...
  3. L

    Options for Access/Excel report printng - Import Excel as a report or push Db data and print Excel sheet?

    I don't have hours/days to recreate that form is the problem, it is beyond my ability or experience to even start trying to recreate visually in access. I have only ever used report wizard and tweaked from there. True it is not a complicated form, but it is quite a large number of cells to have...
  4. L

    Options for Access/Excel report printng - Import Excel as a report or push Db data and print Excel sheet?

    I work for a small repair facility. Prior to me they have used all Excel sheets and physical log books for tracking jobs. Over the last 2 years, I have developed (complete untrained novice, so it is not properly designed or structured, but I am slowly working on that so be gentle) an Access Db...
  5. L

    Report pulling and summing from multiple tables

    Yes and this exactly why I think normalization may be the best way to go. Sheer user laziness/inconsistency causing errors. I have read thru the normalization pages linked earlier and it def makes more sense to me. I had avoided it as I though it was un-needed complexity. I partially...
  6. L

    Report pulling and summing from multiple tables

    No worries at all, I never expected or required an answer. I know my responses on forums at times can come across as dismissive and just wanted to apologize for that and let you know I did appreciate your response and the links, I know they will help. Family is much more important that...
  7. L

    Report pulling and summing from multiple tables

    Thanks for your reply. I was worried that my reply after your initial post had caused you to no longer respond. I was just trying to give everyone a full picture of our situation. Reading it a few days ago I realized it read a bit like I was shutting you down and unwilling to listen to your...
  8. L

    Report pulling and summing from multiple tables

    Yeah Def pretty far into the rabbit hole.. However if Amending is what needs to happen to make the dB more robust and usable long term, it is what needs to happen. Rather do it now than after another year worth of data has to be converted. I just do not know or understand how to break it up...
  9. L

    Report pulling and summing from multiple tables

    This dB is normally split in two. Tables in one dB and all the other items in the other. I compressed back into one file thinking it would be easier for people here to help me. I split it into two so that I could edit forms/reports anytime I wanted to and not affect users. Plus yes they...
  10. L

    Report pulling and summing from multiple tables

    Thanks for the response. Sorry I am so new and clueless with what you are recommending. Not sure I follow on the tasks per job being separate tables? I am open to making changes, especially if it makes my future report generation easier. Just not sure I follow what you are recommending. In...
  11. L

    Report pulling and summing from multiple tables

    Anyone have any ideas or able to help?
  12. L

    Report pulling and summing from multiple tables

    ok, crazy busy morning, finally was able to merge the dB into one file .mdb and zip it. Please be kind, we are a very small company and I am a novice learning as I go, just trying to get them off of Excel sheets and into a more robust and flexible system so it is messy and not very advanced...
  13. L

    Report pulling and summing from multiple tables

    This is not our accounting system We have an entirely separate accounting/inventory system. This is just to aid in job tracking/visibility. The company is very old school and everything is still and will stay primarily on a hard work order/job packet format. 2yrs ago it was just an excel...
  14. L

    Report pulling and summing from multiple tables

    ok, I will review what I need to do to upload when I get to work tomorrow. Interesting point on the query/report aspect. I said I am a complete newby. I could not get the job count data to output like I wanted so I started goofing around and when I made a crosstab it suddenly worked so I...
  15. L

    Report pulling and summing from multiple tables

    Total Novice Access user. While I have used access for years I have only ever needed to use the basic built in features for organizing and tracking information and making basic reports. I am a purchasing/CS guy and have zero training or experience in programming/SQL/Macros, etc. I work for a...
Top Bottom