Search results

I have a problem with crosstab calculation, hope someone could help me. Here's my main table: Office -Project -Performance Balagtas -OSA -90 Balagtas -Billing Complaints -95 Balagtas -Payments -85 Malolos -OSA...

Hi I'm creating an access program that will automatically generate random samples. Samples are generated by using an SQL query and the resulting query is appended to a table. The sample generations works fine by setting criteria thru a textbox inside a form. However, I'm thinking if i could...

here's my problem... i have a crosstab query where in one field (value) has a range of 1 to 19. I used the min and max for two separate row headings.... the min and max works only on values (1 to 9) or (11 to 19) example... the 2 columns have values 8 and 4 the min returns 4 and the max returns...

Hi, I have a survey database file containing the following tables tblQuestions - contains survey questions tblResponse - contains responses inputted by user tblRespondents - contains info on user (e.g. Name, Add...etc) Is it possible that answer to some questions are dependent on other...

Hi, I need help with regards to linking the subform to the mainform. I'am creating sample survey in access. I have a subform that would list the questions on the survey. The subform runs fine and displays the questions that are to be answered. However, when i tried linking the subform to the...

for example i have a query with... field1 field2 field3 a------b-----c my goal is to create a new table with that gets the values of field1,2,&3 and display as a row in a newly created column newcolumn a b c thanks in advance.

Is there a code or command than can automatically scan/sort all the fields on the table without manually entering the individual fields in the code. example i have three fields field1, field2, field3 the code i am presently using is a series of IF THEN statements for each field.I have to write...

Hi guys, I have a main form with tabbed control in it and several subforms. I have a subform on the second tab which has a larger length than the main form. When I run the form and clicked on the second tab, the subform attached on the 2nd tab centers on the screen which means i have to scroll...

I would just like to ask if it is possible to sort the values of different fields in a report. For example I have three fields that contains percentage values percent1=100%, percent2=65%, and percent3=85%. I would like to arrange the values from highest to lowest... desired output would be...

How can I remove the space occupied by invisible fields in my report? I have already used the can shrink feature, but it still leaves a space in the report. many thanks

Attached image is my sample table in ms access 2000. how can I make a report that would show the fields that only have "2'" value. My goal output for my report would sumethin like this... BRANCH: MALATE OSA: 11 RSC: 2 BRANCH: MALATE OSA: 13 CLAMP: 2 BRANCH: MALATE OSA: 14 CLAMP: 2 RSC: 2...