Access 2010: How To Insert Rows / Columns In Query Design
Thank you for taking the time to report an issue.
What's wrong... Please write below.
How do I insert the desired rows without moving EVERYTHING on the formdown?
I need to make a report , with Specified ROWS & COLUMNS filling A4 size page , whether there is no data in all the fileds.
I need to print the report in that format because it is the approved format from my client.
I know if there is sufficient data is there to fill the page, the ROWS & COLUMNS will come. But if I have less datas only to print, I need the page filled with the rows and columns blank.
If it is possible to design the report like this Kindly advise me
I have two columns say column A and D which consists of integer values and the values of the columns are say in the range 1 - 100 ( both the columns ). so there is a row say in column A value is 38 and in column D corresponding value is 37.
So now in the output there should not be any other record with having value 38 and 37 either in column A or D .ie. all those rows which contains these values other than this rows should be omitted.
Similarly for other rows and values also .I tried with the following query but didn't worked
If so, is there some place that will tell me the order of thecolumns when I run the query?
how can I perform basic math on Access db columns? I need to multiply a constant by the present column value ($).
the kicker is also only doing partial rows, I.e. some rows X .96, some rows x .99, etc.
if you could hi-lite rows/columns, then do math would be the ticket!
Between: how on earth could MS build access without this basic function? they want you to buy Excel and import/export!
Can a 2.8ghz, i7 (not sandy) 4gb system handle this OR would adding more RAM help?
It's going really slow right now making the 1st query from the table with about 85,000 rows and 12 columns. Can't wait to combine that with the 20,000 row database with 15ish columns.
I need to convert the last ten columns of data into one column with a second column added to identify the original field name. Then end result would be onecurrent record of data being converted into ten records with the original 10 columns of identifying data, a new column containing the original field name and a column for the data value from the original column identified in the new column.
I have been able to do this in Excel using a consolidation pivot table, un-checking the rows and columns then clicking on the final sum value to get a detailed list of the records. Unfortunately there still appears to be a cap because I get a message saying some of the data has been dropped after a little over a million rows.
I am using the 2010 version of Access and Excel.
This is the smaller table. I have several others that have up to 200 columns that need to be converted the same way.