Search results

Hello! I have a students table with the following details: Reg no, Name, Subject, Category, Points 1324, Silas, English, Compulsory, 10 1324, Silas, Kiswahili, Compulsory, 11 1324, Silas, Maths, Compulsory, 12 1324, Silas, Biology, Science, 9 1324, Silas, Chemistry, Science, 10 1324, Silas...

Hello; I would wish to build a report whose column names vary with the cross tab query field names. The actual thing is that its a students database where the subjects may vary. The report created should automatically include new cross tab query field names more so the subject titles. Further...

Hello; I have the following table structure for a students database: Reg_No Name Class Subject ID Mark 14256 Clint A 100 67 14256 Clint A 101 60 14256 Clint A 102 80 67478 Silas B 100 74 67478 Silas B 101...

Hello all, How can I find the nth maximum value in multiple fields? For example how can I find the 2nd or 3rd or 4th largest value per record in the following sample set of data? ID Name Field1 Field 2 Field3 Field4 Field5 Field6 2ndHigh 3rd High 4th 1 Abbyy 89 78 45...

Hello... I would wish to append multiple records from one table or query to multiple tables like 4 tables or so ONCE using VBA when a command button is clicked. Furthermore, during the process, only new records are added while the existing records are updated How can I go about with this...

Hello... I would wish to find out how i can get only seven maximum fields or two minimum fields in this set of data : ID Name Subj1 Subj2 Subj3 Subj4 Subj5 Subj6 Subj7 Subj8 Subj9 01 John 78 89 65 45 78 67 45 30 54 02 Mark...

Hi! Which code or a query or an expression or a function that can select ONLY Seven highest fields out of eight fields and add them on each individual records. Thanks.

Hello... I would wish to find out how to use a combo box to change the chart type on a form i.e. to change it to either a bar graph or line graph and how to make the graph display details of each record in each graph but not the entire table. Thanks in advance.

Hi… I wish to find out how I can draw grid lines on a report without a record source. Thanks in advance.

Hi… I wish to find out how I can go about with the following in access 2013: 1. Drawing grid lines on a report without a record source. 2. Creating a code or a query or an expression or a function that can select ONLY Seven highest fields out of eight fields and add them on each individual...