Search results

Ok thanks for the comments, i think. Yes I guess Im pigheaded because I dont want to introduce 20000 records to my customers database, when 99.9% of them will never be needed in that db. Its seems ridiculous to combine both tables, re-key, re-connect to sharepoint, check/change all queries...

Thank you for your replay spikepl, but yes 20,000 is alot to me when you are adding orders to those 900 among 20,900. Esp when its not a computer savy person adding the orders. I am sorry that it makes more sense to me, to address only the two tables as opposed to changing the entire structure...

Thank you for your replies jdraw, Im afraid I can not convince myself to enter 20k leads into my orders db. The issues in adding orders manually to me just outweigh the singular benefit. To me, it seems like I am looking for an automated version of update/append/or insert (query) - that goes...

I just looked any my leads db has 19479 unique records. The customer db has 901 "customers" and these customers have over 30000 orders. I fear mixing leads and customers into a single table would create multiple issues syncing/link through sharepoint. I also fear great issues with the orders...

Ok, how about suggestions on this. Whats best approach to sync rows from leads table that contain CustomerID to Customer table (Sharepoint Linked) in the same database? Would this suffice?

For infinity truly or until they close...... then they are changed to inactive. I track, calls, appointments, emails, SIC Codes and business details. Nothing that is different from a customer. They were started in different dbs as I inherited the customer one and it currently has over 30k...

Well maybe the better question is, what is the suggested method to link/sync those "leads" to customer table? But automate it so I dont have to update the information in both leads and customers. I currently have a customer database, it contains, suppliers, orders and sub contacts for each...

Thank you for your reply Mihail, But I would prefer to keep them separate. I have roughly 10,000 leads and 1000 customers. I would prefer to keep the Leads out of the "Sales" database unless they end up with a "order"

Hello, I am looking for some guidance/suggestions on best way to manage a design with Access 2007-2010. I have two db's both in sharepoint if that matters. 1. Customers with orders, linked by customer number A-For customers there are contacts which also are linked by customer number 2. Leads...

Thank you Plog.

Hello, Thank you for your help and review. My [Sales Analysis] query contains fields Principals, Customers, Order Date, Year, Month (is 1-12), Sales, Commission, Order ID The attached screen shot shows report structure I was working on. I would like to pull all sales for a particular...

I need a querry that is set up to ask the following SELECT DISTINCTROW [Sales Analysis].Principal, [Sales Analysis].[Customer Name], [Sales Analysis].Year, [Sales Analysis].Sales AS CurrentSales WHERE [Year] = 2011, [Sales Analysis].Commission AS CurrentCom WHERE [Year] = 2011, [Sales...

Thank you for the reply Spoole, Does this mean I should create an additional table? Currently the querry Sales Analysis includes fields for supplier, customer, year, month, sales and commission. the majority of fields for query [Sales Analysis] is pulled from Orders table. Is it safe to say...

I am attempting to create a report based on [Sales Analysis] query which would pull suppliers, customers with values for Sales & Commission. This report would then show additional columns for Sales & Commission, however they would be for last years sales or same month last year. I seem to be...

I finally got this to work, yippieeeeeeeeeeeeeeeeeeeeeeeeeeee. Happy new year to me.

I need help please, I have fooled with this scenario for months now and seem to have hit a wall. I my db uses forms like northwinds 07 (I believe) in which you select the "grouping" fields such as customer, location, employee etc. I am attempting to be able to pass these parameters through...

Can someone please help? Why is it this code works in query SQL View, but not as VBA string named strSQL? strSQL = "TRANSFORM CCur(Nz(Sum(IIf([FieldName]=""Sales"",Nz([Sales],0),Nz([Commission],0))))) AS TheValue" strSQL = strSQL & " SELECT [Sales Analysis].Principal, [Sales...

Is it possible to 1. Assign Dynamic Columns to a crosstab style report? 2. Pass variabless to same? 3. Dynamically assign values to same? If you can create the query and the report you have to be able to pass variables through to this kind of report, right? Urgh.........

I am attemtping to add additional column headings to create a crosstab query. I have worked out the scenario to do this through query design and then based a report on same query. I am now trying to assign variables through a form. I feel as though I have tried every option and still get errors...

Changing the search text fields to txtName seems to work very well. Thank you.