Append Query Problem 1

[bpifer23]

I have an append query that takes some calculated values from another query and transfers these values into a table to allow myself to keep a cumulative total of these values for a report. The problem I am having is that when these values go from the append query to the table, the format does not stay. All my values need to keep 2 decimal points and they all get rounded. I tried changing all of the format properties of the table and I still keep coming up empty.

Any suggestions would be great.....Thanks a head of time.

Brian

 

[JonFer]

Please post the SQL for your append query.

BTW, if you could calculate a cumulative total at any time with a query, would you need this table?

 

[bpifer23]

Thanks for your help.......I did not even think about not needing the append query. Because you knocked some sense into me, I probably will not even use the append query but if you want to look at it and let me know what i did worng, that would help too. Here is the SQL (it is really big because of the number of fields in this database).

Thanks Alot Again......Brian

INSERT INTO cumePerfReview ( sid, [select date cume], [serializemat hours], [serialize material pprating], [serialize material level], [serializecred hours], [serializecred pprating], [serialcred level], [lab hours], [lab pprating], [lab level], [filecred hours], [filecred pprating], [filecred level], [refilecase hours], [refilecase pprating], [refilecase level], [staplecred hours], [staplecred pprating], [staplecred level], [filemat hours], [filemat pprating], [filemat level], [scancaeve hours], [scancaeve pprating], [scancaeve level], [condshe hours], [condshe pprating], [condshe level], [misfileswe hours], [misfileswe pprating], [misfileswe level], [stacrt hours], [stacrt pprating], [stacrt level], [pullcrt hours], [pullcrt pprating], [pullcrt level], [pullsys hours], [pullsys pprating], [pullsys level], [update hours], [upitemre pprating], [upiteeve pprating], [upko pprating], [upcaseeve pprating], [upitemre level], [upiteeve level], [upko level], [upcaseeve level], [sortup hours], [sortup pprating], sortuplevel, [jcases hours], [jcases pprating], [jcases level], [sysnaclc hours], [sysnaclc pprating], [sysnaclc level], [sysanaci hours], [sysanaci pprating], [sysanaci level], [upCC hours], [upCC pprating], [upCC level], [fileCC hours], [fileCC pprating], [fileCC level], [sweepCC hours], [sweepCC pprating], [sweepCC level], [photo hours], [photo pprating], [photo level], [closenaclc hours], [closenaclc pprating], [closenaclc level], [closeanaci hours], [closeanaci pprating], [closeanaci level], [cct hours], [cctphonecalls pprating], [cctfaxes pprating], [cctpullcase pprating], [cctso1vo pprating], [cctphco pprating], [cctmailout pprating], [cctphonecalls level], [cctfaxes level], [cctpullcase level], [cctso1vo level], [cctphco level], [cctmailout level], [mailanacinaclc hours], [mailanacinaclc pprating], [mailanacinaclc level], [serialcas hours], [serialcas pprating], [serialcas level], [utls hours], [utls pprating], [utls level], [daily hours], [daily pprating], [daily level], [aff hours], [affmail pprating], [affprocess pprating], [affko pprating], [affupdate pprating], [affCR pprating], [affmail level], [affprocess level], [affko level], [affupdate level], [affCR level], [dss hours], [dss pprating], [dss level], [missitcas hours], [missitcas pprating], [missitcas level], [RHvo hours], [RHvo pprating], [RHvo level], [PA hours], [PA pprating], [PA level], [ADMIN ERRORS] )
SELECT queryPerfReviewTwo.SID, queryPerfReviewTwo.[Select Date], queryPerfReviewTwo.[SumOfserializemat hours], queryPerfReviewTwo.[SumOfserialize material pprating], queryPerfReviewTwo.[serialize material level], queryPerfReviewTwo.[SumOfserializecred hours], queryPerfReviewTwo.[SumOfserializecred pprating], queryPerfReviewTwo.[serialcred level], queryPerfReviewTwo.[SumOflab hours], queryPerfReviewTwo.[SumOflab pprating], queryPerfReviewTwo.[lab level], queryPerfReviewTwo.[SumOffilecred hours], queryPerfReviewTwo.[SumOffilecred pprating], queryPerfReviewTwo.[filecred level], queryPerfReviewTwo.[SumOfrefilecase hours], queryPerfReviewTwo.[SumOfrefilecase pprating], queryPerfReviewTwo.[refilecase level], queryPerfReviewTwo.[SumOfstaplecred hours], queryPerfReviewTwo.[SumOfstaplecred pprating], queryPerfReviewTwo.[staplecred level], queryPerfReviewTwo.[SumOffilemat hours], queryPerfReviewTwo.[SumOffilemat pprating], queryPerfReviewTwo.[filemat level], queryPerfReviewTwo.[SumOfscancaeve hours], queryPerfReviewTwo.[SumOfscancaeve pprating], queryPerfReviewTwo.[scancaeve level], queryPerfReviewTwo.[SumOfcondshe hours], queryPerfReviewTwo.[SumOfcondshe pprating], queryPerfReviewTwo.[condshe level], queryPerfReviewTwo.[SumOfmisfileswe hours], queryPerfReviewTwo.[SumOfmisfileswe pprating], queryPerfReviewTwo.[misfileswe level], queryPerfReviewTwo.[SumOfstacrt hours], queryPerfReviewTwo.[SumOfstacrt pprating], queryPerfReviewTwo.[stacrt level], queryPerfReviewTwo.[SumOfpullcrt hours], queryPerfReviewTwo.[SumOfpullcrt pprating], queryPerfReviewTwo.[pullcrt level], queryPerfReviewTwo.[SumOfpullsys hours], queryPerfReviewTwo.[SumOfpullsys pprating], queryPerfReviewTwo.[pullsys level], queryPerfReviewTwo.[SumOfupdate hours], queryPerfReviewTwo.[SumOfupitemre pprating], queryPerfReviewTwo.[SumOfupiteeve pprating], queryPerfReviewTwo.[SumOfupko pprating], queryPerfReviewTwo.[SumOfupcaseeve pprating], queryPerfReviewTwo.[upitemre level], queryPerfReviewTwo.[upiteeve level], queryPerfReviewTwo.[upko level], queryPerfReviewTwo.[upcaseeve level], queryPerfReviewTwo.[SumOfsortup hours], queryPerfReviewTwo.[SumOfsortup pprating], queryPerfReviewTwo.sortuplevel, queryPerfReviewTwo.[SumOfjcases hours], queryPerfReviewTwo.[SumOfjcases pprating], queryPerfReviewTwo.[jcases level], queryPerfReviewTwo.[SumOfsysnaclc hours], queryPerfReviewTwo.[SumOfsysnaclc pprating], queryPerfReviewTwo.[sysnaclc level], queryPerfReviewTwo.[SumOfsysanaci hours], queryPerfReviewTwo.[SumOfsysanaci pprating], queryPerfReviewTwo.[sysanaci level], queryPerfReviewTwo.[SumOfupCC hours], queryPerfReviewTwo.[SumOfupCC pprating], queryPerfReviewTwo.[upCC level], queryPerfReviewTwo.[SumOffileCC hours], queryPerfReviewTwo.[SumOffileCC pprating], queryPerfReviewTwo.[fileCC level], queryPerfReviewTwo.[SumOfsweepCC hours], queryPerfReviewTwo.[SumOfsweepCC pprating], queryPerfReviewTwo.[sweepCC level], queryPerfReviewTwo.[SumOfphoto hours], queryPerfReviewTwo.[SumOfphoto pprating], queryPerfReviewTwo.[photo level], queryPerfReviewTwo.[SumOfclosenaclc hours], queryPerfReviewTwo.[SumOfclosenaclc pprating], queryPerfReviewTwo.[closenaclc level], queryPerfReviewTwo.[SumOfcloseanaci hours], queryPerfReviewTwo.[SumOfcloseanaci pprating], queryPerfReviewTwo.[closeanaci level], queryPerfReviewTwo.[SumOfcct hours], queryPerfReviewTwo.[SumOfcctphonecalls pprating], queryPerfReviewTwo.[SumOfcctfaxes pprating], queryPerfReviewTwo.[SumOfcctpullcase pprating], queryPerfReviewTwo.[SumOfcctso1vo pprating], queryPerfReviewTwo.[SumOfcctphco pprating], queryPerfReviewTwo.[SumOfcctmailout pprating], queryPerfReviewTwo.[cctphonecalls level], queryPerfReviewTwo.[cctfaxes level], queryPerfReviewTwo.[cctpullcase level], queryPerfReviewTwo.[cctsov1vo level], queryPerfReviewTwo.[cctphco level], queryPerfReviewTwo.[cctmailout level], queryPerfReviewTwo.[SumOfmailanacinaclc hours], queryPerfReviewTwo.[SumOfmailanacinaclc pprating], queryPerfReviewTwo.[mailanacinaclc level], queryPerfReviewTwo.[SumOfserialcas hours], queryPerfReviewTwo.[SumOfserialcas pprating], queryPerfReviewTwo.[serialcas level], queryPerfReviewTwo.[SumOfutls hours], queryPerfReviewTwo.[SumOfutls pprating], queryPerfReviewTwo.[utls level], queryPerfReviewTwo.[SumOfdaily hours], queryPerfReviewTwo.[SumOfdaily pprating], queryPerfReviewTwo.[daily level], queryPerfReviewTwo.[SumOfaff hours], queryPerfReviewTwo.[SumOfaffmail pprating], queryPerfReviewTwo.[SumOfaffprocess pprating], queryPerfReviewTwo.[SumOfaffko pprating], queryPerfReviewTwo.[SumOfaffupdate pprating], queryPerfReviewTwo.[SumOfaffCR pprating], queryPerfReviewTwo.[affmail level], queryPerfReviewTwo.[affprocess level], queryPerfReviewTwo.[affko level], queryPerfReviewTwo.[affupdate level], queryPerfReviewTwo.[affCR level], queryPerfReviewTwo.[SumOfdss hours], queryPerfReviewTwo.[SumOfdss pprating], queryPerfReviewTwo.[dss level], queryPerfReviewTwo.[SumOfmissitcas hours], queryPerfReviewTwo.[SumOfmissitcas pprating], queryPerfReviewTwo.[missitcas level], queryPerfReviewTwo.[SumOfRHvo hours], queryPerfReviewTwo.[SumOfRHvo pprating], queryPerfReviewTwo.[RHvo level], queryPerfReviewTwo.[SumOfPA hours], queryPerfReviewTwo.[SumOfPA pprating], queryPerfReviewTwo.[PA level], queryPerfReviewTwo.[SumOfADMIN ERRORS]
FROM queryPerfReviewTwo;

 

[JonFer]

Your append query isn't adjusting anything from queryPerfReviewTwo so I need to see that query. You can cut down on the number of fields - just show some that don't keep the decimals. Just to double-check, you are using Double or Currency for the field type in the "append to" table, right?

 

[bpifer23]

ok sounds good.....thanks for all your help

brian