Search results

nopes, i am talking about "Columns To Repeat" on a report!!!!

Hi I am trying to duplicate an Excel spreadsheet. i have one problem, i don't know if there is a way to have some columns reprint on each page. thanks, sam

i am not sure where your promt is, but somewhere along the way (either in a query or in a report) there is a promt. that promt in design view is in the criteria or something like that. you need to direct that parameter to a form. so it would be criteria: Forms![MyForm]![MyDataField] try to look...

in the properties of the field (design view) set it "can grow" to "no" sam

I would check the sub with out the main if its working fine.

your parameter for each of the queries should be a text box thats on a form, so that you don't need to enter it 3 times. sam

you might need to first create a union query and then a crosstab query.

why not? you can use first or last instead of sum or other mathematical groupings. should work. sam

sorry, but i was having problems with this one as well. i have a posting where i state that i have problems with this. sam

thanks a lot. i am now reworking my queries and consilidating them a bit. however, i think that it would be nice to add multiple recordsets to a report. (obviously not in a subreport) sam

i don't think i understand exactly what you want to do. i will tell this, if you want you can create subFooters. basically go to top (toolbar) and find the icon for Sorting/Grouping and you can have many groups. if you would like a total after a group then on the Sorting/Grouping screen you...

in these forums its hard to teach access. the forums are for specific difficulties that some one has with creating something, maybe trouble shooting some other issues. i suggest you buy yourself a book and learn a bit more about access. sam

in the report header you should be able to add a textbox =sum([GroupA]) and another textbox =sum([GroupB]) sam

Thanks for your reply. It definetly opened my eyes to something i haven't thaught about. However, this is my situation. each date range must split up date with an if statement. basically my data is not based by day it is by payperiod, which means i need to split up a span of two weeks and take...

Hi I was wondering if anybody has some ideas. i need to create a report that has three years of history. it is hard to describe the entire project, but i will describe it breifly. the user enters a date range (usually would be jan 1 until some date within the same year). i then want to show...

please post your code. sam

in the double click event (on the properties) enter even procedure. build the event in VBE. call popupcalendar(screen.ActiveControl) and then do continue to write here the weekday function. ... end sub good luck, sam

Please view this post: http://www.access-programmers.co.uk/forums/showthread.php?t=101403 what i recommend is that you create a query that will call your split function and would replace the ". and they you can use the replace on CboSearchItem. good luck, sam

you can this on the Northwind database. the invoice form has this. good luck, sam

docmd.gotorecord.. never used it, but i think thats what you want. good luck, sam