Search results

Hi David, Which way did the ERP system operate, separate tables or the address type method?

I agree completely, a Customer/Client is the same thing when designing database tables. In my situation, I still believe I need the following hierarchy: 1st Level - "Client" This client/customer address is the top level of the tree, a large 'group' business or maybe a business that is...

Hi jdraw, thanks for your thoughts. I thought about including a tblClientType later with two entries 'Commercial' and 'Residential'. Then use a Lookup field in the "Clients" table to identify which type applies to each Client? My initial idea was to use a tblAddressType but I couldn't think it...

Ok, I've finally worked out what my model is... A "Client" can have many "Customers" A "Customer" can have many "Sites" A "Site" can have many "Services" Also: A "Service" can be used by many "Sites" A "Site" can belong to many "Companies" (rare, although it can happen) Does the attached...

That's great, I'll have a look at it now...

Hi David, Is that an MS Access file? I'm on Office 2003 so can't open that file... Thanks Brian.

Hi David, Your suggestion would probably work fine if a customer was only 1 of the 3 options listed. I don't think it would work in my situation, as I would like to mark an address as inactive if it ended but I wouldn't be able to do this if there were other sites and/or services active for that...

Hi all, I've tried looking for a suitable Data Model but I can't find one to fit what I'm aiming to achieve. I have "Residential" and "Commercial" customers. The Residential customers are nice and easy as they usually have a single address for Billing, Company & Delivery purposes. However...

Finally worked it out, seems fine but I'll need to check the results for errors: =DCount("[Billable Hours]","Alarm Response - Data Entry - Query 2","[SIC] = [Keyholding] And [Date of Arrival] >= [Bundled From] And [Date of Arrival] <= [Bundled To]")

Ok, after a bit of tweaking I can return the correct number of previous orders but without the date criterion. =DCount("[Billable Hours]","Alarm Response - Data Entry - Query 2","[SIC] = [Keyholding]") I now need the DCount function to just return the orders between two dates. Can I add this...

Thanks for the clue nathansav, I've just had a look at the DCOUNT function but I can't get it to work. Can you seen anything blatantly obvious with the expression below? (Apart from the lousy naming conventions etc.) DCount ("[Billable Hours]", "Alarm Response - Data Entry - Query 2", "[Date...

Hi all, I want to count the total number of orders between two dates for a particular customer. I can get the result in a query by using parameters but I want the result to show in a subform without anyone typing the parameters in. I'm currently using a Form to enter details of customer...