the names are from a sepporate table of names drawn in by a form with a combo box pointing to that table.
the structure is
tickets
Requester Text (List from table of names)
Date Reported Date/Time
Description of Problem Memo
Programs Opened Memo
Resolution Date...
i want to make a report that sorts by the name of the person and then by a check box. i have tried to sort by the name and it never works right. i have seperate tables for the name.
can that be seporated clearly in a report. i just want the data to be able to report clearly that a job is done or isn't i really don't care how, but i have to be able to sort it in the report
i added a check box to my form to check off when a job is completed. i want the data that shows in the table to be a 1 for checked and a 0 for not checked. right now it comes out as a negative or a positive 1. any thoughts?
i just typed it, but i put in the selected fields.
Date 12/20/03
Steven Zarrella
123 Warwick Road
Watertown, CT 06795
Dear Steven,
I put in a date field i locked some of the other words like dear.
i am having tremendous trouble formating a pivot table form in access. i have to do my reports this way for my boss. its easier to control the amount of data in access. when i load a pivot table in access 2000 once it gets to the excel wizard it only loads 16 million or so records before it...
ok i am creating a pivot table in access 2002. is there a way to format it so there are percets and so you can turn the row headings facing up instead of horizontal?
i am setting up a pivot table form that has severale tables involved. everytime i go to setup the pivot table excel gives me the error message that i don't have enough memory. i have 384mg. i know excel can only handle 16 million records. is there a way to change that or am i going to have to...
i was trying to combine tables to make a pivot table and when it was counting the records to create the table excel comes up with an error "Not enough memory" any thoughts on how to change that? i have upgraded memory and shut off everything on my computer except access and excel.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.