Recent content by Sketchin

Thanks MajP, I think I follow the logic here and believe it might work. I will follow up if I need any clarity. Thanks for taking the time to help me out!

The workflow will begin with the user creating a new quote and adding a list of parts and labor items to it. From there, they will select the specific tasks that were performed—such as changing brakes or replacing suspension—and enter the number of hours required for each task. Parts can then be...

I am building a database for generating quotes for a service shop and am struggling with how to handle our flat rates and special rates for customers. There is a fixed list of tasks that are considered a flat rate, stuff like Visual Inspection, Pressure Test, Steam, Sensor Inspection... and so...

Thanks for the feedback, I think that is a great idea due to the reduced complexity. Intuitively I was thinking there was a better way, but I just couldn't quite get there to see it.

Hello, I am designing a database for a tank trailer repair shop and need a bit of guidance on how to structure my tables. At a high level, the user will input a Work Order# and all relevant info into a parent form (customer, PO#...etc). They will then choose tasks on a subform (changed...

Geez, I am out of practice.... Now I see how # is being used, it is saying that everything between the #'s is a date. #" & [Forms]![frmdashboard]![txtDateTo] & "# It's been a VERY long time since I have actively developed! Thanks for the help.

I have a criteria in a DCount that says "MinOfDateout < #" and have no idea what < # is doing. MinOfDateout is a field in a query. The entire string looks like this: UNICompaniesSupportedCumulativeAB = Nz(ECount("[MaxOfContactID]", "QryCumulativeMetricsNew", "[State/Province] = 14 AND...

You are a legend! Putting it in the OnClose event will work, I just need to make sure I figure out which form I came from since there are up to 5 that the user could have came from.

I have a form that shows project details including some financial information related to my project. In order to update the financials, or add some transactions, I click a button that opens a transactions form. On that form, I enter the data required and then close it to return to my project...

I have this query expression that gives me a #NUM! error due to div/0. PercentPaybackToDate: FormatPercent(((Sum(IIf([TransactionTypeID]=5,Nz([Amount]),0)))/(Sum(IIf([TransactionTypeID]=9,Nz([Amount]),0)))),0) I can't for the life of me figure out how to test for a zero value in [Amount] to...

Alright, I think I am good for now. For some reason, sorting isnt workign in Access, but I can do it in my linked Excel Sheet. Thanks for the help!

I made an adjustment tothe calculation because the program type doesn't really matter, its just the Company Name and Engagement Date that are important. I am closer to a solution, but now am missing data! CompanyName Engagement Date ProgramType EngagementOrder 4iiii Innovations Inc...

Hi plog, Thanks for the reply. I implemented this and it didn't quite work. Here is a sample of the data output that should give you an idea of what went wrong. CompanyName Engagement Date ProgramType EngagementOrder 4iiii Innovations Inc. 1/22/2013 TAP 1...

Plog, here is a sample of the RAW data: Company Name Engagement Date Program Company A 5/9/2015 IND Company A 5/9/2016 GEO Company A 5/9/2017 TAP Company B 5/9/2015 GEO Company B 5/9/2016 IND...

Thanks for the reply. Yes, I am ordering engagements by the date field. I believe that in order to do this in a crosstab, I would first need to create a query that has a calculated field that somehow determines the number of engagement (1st, 2nd...etc.) From there, I could use that calculated...