Search results

ok I did figure out how to do it when the call lasts at least a minute callduration: DateDiff("n",Left([contactcalldetail]![startdatetime],10) & " " & Right([contactcalldetail]![startdatetime],8),Left([contactcalldetail]![enddatetime],10) & " " & Right([contactcalldetail]![enddatetime],8))...

I have a table, from a Cisco call application. It gives me the call start date/time and call End date/time. However as of right now it gives it to me in text format. :banghead: I have no idea why a data base would store date time as text but it does. Anyway long term I am going to contact...

all good points thanks. I was just hired 2 months ago. All of this was prior work I am just starting to clean up. I had a quick deadline so I am using what was there, and then updating the processes for 2015. I am sure I will be asking more questions later. Many thanks, I had about 2 lines...

so for query output custid cellcode 2015qty 2015forecast jan feb mar apr may 769 1234 100 1,000 3.875 3.958 3.788 3.889 4.25 is calculated as follows (where the number in BLUE are pulled from tbldata, and the numbers in RED are pulled...

example for tblsalesallocation 93 20 jan 95 20 feb 100 22 mar 98 21 apr 102 20 may the total of field mnthallocation will ALWAYS total 1,200. So sales manager could change Jan to 98, but then some other month(s) would be lowered by 3 points. Regardless the divider is always 1,200

example for tbldata 769 1234 100 1,000.00 769 1235 200 2,000.00 769 1236 300 3,000.00

tbldata: custid cellcode 2015qty 2015forecast tblsalesallcoation mnthallocation mnthworkdays mnth

sorry you are correct, I wrote this question, then tried something and forgot I changed the field names and then just copied paste the question in. give me a minute and I will update. the screen shot is the updated information, but hold on

on the surface this seems easy, but I am struggling. two tables tbldata (four fields 6,270 rows) custid 2015cellcode 2015qty 2015amt 12673 1243 100 1,000.00 12673 1250 200 2,000.00 etc etc tblmntlyalloc (Three fields and 12 rows i.e...

yea, 99% of our efforts are taking data from two legacy ERP systems, loading the data into MS Access, creating simple queries that have some formulas and roll ups, then having the financial end user community link excel pivot tables to the predefined queries. I have 6 major queries that about...

ok an "issue" since using this formula this formula was used in a simple select query. No criteria, or grouping etc. when I run the query it gives me a correct answer set. I have an excel pivot table connected to the query. This formula is also in the query repairtime...

that worked just fine. For what we are doing, the first week can be 1/1/XXXX. I understand for many, Week 1 REAL start date is important, but for this project week 532013 vs 12014 is not an issue. We are doing a rolling 26 week average, so it will not affect the numbers. Again many thanks for...

I have an excel formula that I need to work in Access. I was thinking it was a straight copy, but must need slightly different formula in Access. so in excel I have this cell A1 Cell B1 GS1A1426 62014 Formula in B1...

thank you so much for your help. Yes this application was built over time and takes a feed from our ERP system. The users requested the field names match the ERP system. In hindsight, I should have made the MS Access field names correct, and just gave them "alternate" names for displaying in...

I have a query, and an IIF statement. It is simple and work perfectly. I need to adjust it, and cannot seem to think of how. cashflowagingdetail: IIf([tbldatahistory]![monthyear]-90>[due date],">90",IIf([tbldatahistory]![monthyear]-60>[due date],">60",IIf([tbldatahistory]![monthyear]-30>[due...

field one, is Modelin (this is the model we received into repair facitly) field two is Modelout (this is the refurbished model after repairs) Field three is Qty (i.e the number of models we refurbished) so in line 2 we received in 7 DLP2204/17 and repaired them to a DLP2204/17X but our old...

I have an old ERP system. The upload function is one line per value. So if I want to upload 7 models I need 7 lines, not one line with Qty of 7 however my source system sends the data as one line with Qty of 7 DLM2245/17 DLM2245/17X 1 DLP2204/17 DLP2204/17X 7 DLP2249/17 DLP2249/17X 7...

thanks it worked perfect. exactly what I needed. And I understand what you did. In escence the first union query created a "unique" set of models. Then the 4th query combined the three queries, using that unique set. I can use this again and again thanks.

from a previous post I tried this SELECT [tbl1].model, [tbl1].[Sum of Inbound], [tbl1].[Sum of Outbound], Nz([tbl2].arrival,0) AS IFSARRIVAL, Nz([tbl2].OESHIP,0) AS IFSOESHIP From tbl1 LEFT JOIN [tbl2] ON [tbl1].model = [tbl2].model UNION SELECT [tbl2].model, Nz([tbl1].[sum of inbound], 0)...

table 1 model, arrivals, shipments table 2 models, arrivals, shipments some models are in table 1 but not in table 2, and some models are in table2 but not table 1 I need this output model(either tbl1 or 2), tbl1arrival, tbl1shipments, tbl2arrival, tbl2shipments. i.e. I need one line for...