Search results

either have the user click on file print or user the docmd.openreport "reportname" , acviewnormal

are they entering the duplicate records one by one? if so just create a duplicate record button. otherwise you would have to use a loop with addnew on a table recordset having the user specify how many records they want to create. do until txtval = 50 docmd.addnew loop

try switching you syntax nz(sum(value),0) also create header groupings to calcualte sums for specific headings

Thanks for the info, i do need the groupings for totals and best visibility. I think i'm going to end up creating separate reports with specifics on the sorting. thanks again.

Hi. thanks in advance to all that can help i need to sort a report via parameters set by a user in a form. i have a report with factory and customer groupings, but the parameters allow the user to set a sort of orderamount desc. i've tried reassigning grouplevels, turn on order by on, and...

Does anyone know a way to make this code work. I'm trying to get the percent total (curyear/sum(curyear))*100 the sum is messings things up when reworking it with a query so i created the code below but i get an error 3073, not being able to update . thank you in advance to anyone that can...

I know i know, double posting.. sorry posted it in wrong thread figured i get more hits this way... if anyone of you experts can help i'd greatly appreciate it. Structure: customer table - custid pk factory table - facid pk transaction table - custid - facid - orderdate - amount The...

thanks for the input RV . i may have left to clarify that i need both the records of the factories and customers that match the criteria and the records that do not, in a crosstab type of view, at this point i'll settle for a report! as shown cust1 and cust2 have values, but cust 3 only meets...

I've been busting my head on this, Thank you in advance to everyone that can help. Structure: customer table - custid pk factory table - facid pk transaction table - custid...