Search results

Thanks @llkhoutx and @lagbolt. Love the ideas so far. lagbolt, I think if the data requirements were simpler, that idea would work great! While the idea about the date1 etc might offer flexibility in some cases, I want to capture pretty specific data for company contacts and very different...

I have researched the 'party' data model but it is a bit too complex for what I'm seeking. For those familiar with it, I don't really need the intermediary relationship from-to tables. I'm interested in ideas about setting up a data structure that will allow users to search contacts or select...

Hey Mark...just logged on to the board and realized I had forgotten to respond to this post. I ended up using a junction table to match the schema of the CRM app we are migrating to. Thanks for your thoughts.

I need some help with table structure. I have tblCompany with company details and tblEmps with employee details. CompanyID is an FK in the employee tbl to identify their company. I have to track some subscription-like transactions. One type of transaction is where a company allocates an...

Q3:confused: I know I said I will concentrate on entities first but I'm reviewing this data model from @boblarsons sticky post for ideas http://www.databaseanswers.org/data_models/online_banking/online_banking_showing_attributes.htm In the Accounts table, it shows a field called...

Q2 :confused: What would you suggest is the best practice for commissions? Commissions will be paid on to both brokers and their firms. They will also be paid upon the sign up fee and each deposit into the employee account. Rates may vary. Does it make sense to add the actual rate to 2 fields...

I am seeking coaching from normalization experts as I build a data model for a temporary database that will house local data for now but will be translated to the website we're building. The web-based database will be developed by a professional programmer but we need a temporary solution since...

That's exactly what I needed. I knew the way I setup the product table wasn't properly normalized but sleepy brain couldn't get to the correct structure. Thanks Uncle G

This seems kind of simple but I'm having trouble wrapping my head around it and haven't found exactly what I'm looking for. I need some help on a schema for an order management system that considers... * multiple sales tax rates on a product * Tax_2 might be compounded after Tax_1 is...

Although I don't completely follow it, I will figure it out and I'm sure it's going to work brilliantly for me Bob - thanks! Wondering if you or any one else knows much about MAC's. If this app is deployed on a Mac that is running Access as a native Windows app (I think he's running a...

I want to be able to output a report to pdf and specify the filename but allow the user to select the path. Currently using this... DoCmd.OutputTo acOutputReport, "rptRateCard", acFormatPDF, ("RateCard" & Format(Now(), "mmmyyyy") & ".pdf"), True If I leave the OutPutFile parameter...

Thanks AGAIN! I will try that out later today.

2+2, I tried to figure out what you meant but couldn't figure out how to make it work. For your interest, I did find a DateDiff calculation here that ignores weekdays... ((DateDiff("d", dte1, dte2) - ((DateDiff("ww", dte1, dte2, 7) + DateDiff("ww", dte1, dte2, 1))))) Microsoft published a...

Thanks 2+2. I am trying your idea. I think I understand it...if not I'll let you know! ML!

Hi Brian, Yes your assumption is correct, sorry that I didn't explain that very well. But I capture the start date in the table not the end... tblPhase PhaseID (pk) ProjectID (fk to project detail table) Phase PhaseDateChange ...PhaseDateChange is the day that the Phase starts. So if...

Hi Dave, Actually the title of the thread is now misleading. I now have to calculate the number of days between each of the dates in the recordset. For project 27 I need to know that there were x number of days in each phase. So in my report I might end up with: START DATE: NOV 1 2010...

Good reminder Wayne. The issue is that the max date doesn't really work for me by project, by phase yes but not by project. I have to show number of days between from phase to phase but only on active projects. What do you think about using a query def to restrict the recordset to active...

Helps a lot Wayne. Thanks. Your first option appears most flexible, in case my client wants a different metric down the road. I will report back when I have a working model. Thanks again, ML!

I need some creative ideas... I have a table that tracks project phase changes tblPhase PhaseID (pk) ProjectID (fk to project detail table) Phase PhaseDateChange We track a project as it moves through, typically 6 phases: Initiation Verification Analysis Fulfillment Implementation &...

Bob, I am EVER so grateful! You have literally saved me hours and hours of trying to figure out a better solution virtually every time I encounter it. Don't you just love Allen Browne?! I can't believe I didn't consider looking there for a resolution. The simple nugget that JET SQL expects...