I have about 10 columns with data in each column...the columns dont need to show every time. I want to set it up where the user pics the column heading from a drop-down menu and then that column alone will show, none of the other columns are visible...can this be done?
View RepliesHello to everyone!!!i need to ask somethingI CREATE I DYNAMIC QUERY .....HOW CAN I CHANGE THE NAME OF THE COLUMN HEADINGS?THANX IN ADVANCE
View 1 Replies View RelatedI have inherited an Access 2003 database and have been asked to improve the functionality of said database. Specifically, I have been asked to create some charts for improved reporting. I used the wizard to create a crosstab query to support the chart(s):
Code:
PARAMETERS [Forms]![Switchboard]![ActualDate] DateTime;
TRANSFORM Sum(qryPMCompletion.CountOfWOs) AS SumOfCountOfWOs
SELECT qryPMCompletion.PA_Priority
FROM qryPMCompletion
GROUP BY qryPMCompletion.PA_Priority
PIVOT qryPMCompletion.wo_Completed
WITH OWNERACCESS OPTION;
Now what has happened is that the wo_Completed is a Yes/No field so my column headings and therefore my legend comes up as "-1" and "0" instead of "Closed" and "Open".
Is there anyway to change the name of the column headings or shall I just create my own legend?
Looking for a way to list / print column headings in a table.
View 2 Replies View RelatedI am using Access 2000. I have created a crosstab query to run monthly reports based on a fiscal calendar year. My problem is that my column heading is a parameter [Fiscal Period] that returns the fiscal week #s as column headings and they change for each fiscal period. I cannot find a way to list these in the properties box as column headings and therefore they will not display as field names and I cannot create forms or reports from them. Can anyone help?
View 11 Replies View RelatedHello,
can the following be done? :confused:
I have a one-rowed query, with the following column headings and values:
(see pic1)
I want similiar columns to be grouped and their respective values to be summed.
I.e.
(see pic2)
Can someone plese tell me how this is done in SQL?
I could just add the columns manually through the Design-View, but this would cause that new column headings that are added in the future to not be reflected in the query.
Jean
I have a query that creates a table.
I then use another query to sort and remove duplicate entries, using the 'Totals' option Group By and Last.
I then export the datasheet to an Excel spreadsheet.
All goes well, except that the headers on the spreadsheet show LastOfXXXX or GroupByXXXXX. Now I can run a replace function in Excel to remove LastOf and GroupBy from each column header, but it would be more useful if the replace routine was performed prior to the export to Excel.
I have a Graph that uses a crosstab query to generate the data. Its only a simple query. One of the fields is project type, but in the query this changes to a number instead of text? I would like to have this as text but don't know how to go about it. I have searched forums and tried Allen Browne's suggestion on specifying column headings but no luck.
I have attached the initial query and the crosstab query in the screen shot as well as the graph. My aim is to get the project names in the legend, instead of 1, 2 as shown.
Not sure if there is a quick answer but I am trying to complete a crosstab query that references a lookup table. I cannot remove the lookup tables because the database was designed by a consultant. The lookup table is referenced as the column heading. The query works fine until I change the column headings in the properties box - it returns the column headings but there are no values. Am I doing something simple wrong or is it having troubles because it is a lookup table for column headings.
View 3 Replies View RelatedIs there a way of changing the column heading names on the split form portion of an access form. I tried changing them using a query to populate the form and changing the caption of each field in the query and that didn't work. I also tried adding a [Caption] at the design level of the table and that had no affect also. The split form seems to be displaying a portion of the actual field name or something like that.
View 3 Replies View RelatedIs it possible to tell VBA to sum up all columns with the column name containing a special string.
For example I want to sum up all columns containg 2013 as a column name.
I created a csv to allow me to update sage act witht he contents. The problem is that the csv file adds the Field Headings which is causing act to fail to recognise any of the data to import.
When i created a blank csv file without these headings, the data was recognised and available for import. My question is... how do i get rid of these headings?
Thanks
Allan
I have a created a crosstab query which gives me the results I need, but I want to sort the row headings differently. These are not numbers, but machine sizes which range from 4 Metre to 20 Metre. Currently, the crosstab gives me:
10 Metre
12 Metre
14 Metre
17 Metre
20 Metre
3 Metre
4 Metre
5 Metre etc
But I need to show it as:
3 Metre
4 Metre
5 Metre
10 Metre
12 Metre
14 Metre
17 Metre etc.
The field is short text data type and data comes from an ODBC linked table to SQL server table, and I am using Access 2013.
I've setup some crosstab queries with good success and set column headings that appear with blank spaces when there's no data as expected, but I have 1 report that is formatted with set row headings (its a specifically formatted report that i need to produce, that i can't just change).So I need to basically do the same but with the row headings set (I have got the crosstab working, just not showing the rows with no data as yet).
View 3 Replies View RelatedI found the following code to copy the results of a query to the clipboard.
Code:
DoCmd.OpenQuery "DataLoadTemp_qry", acViewNormal, acEdit
DoCmd.SelectObject acQuery, "DataLoadTemp_qry"
DoCmd.RunCommand acCmdSelectAllRecords
RunCommand acCmdCopy
DoCmd.Close acQuery, "DataLoadTemp_qry", acSaveNo
It works great, except that it is also copying the column headings. Is there any way to copy only the results without the headings?
I'm copying this data to the clipboard because I want to be able to paste it in a program called DataLoad which will load this data into one of our company's legacy systems.
I have a link to a "csv" file. I then run a query to exclude some rows.
Then I need to export the query result as a text file with quotes (as text qualifier) and semicolon (as delimiter). This is not a problem. The problem is, that I only need the text qualifer for the data in row 2+ and not the headings.
The data export should look like this:
ID;Contract;Date
"1";"4700001360";"20150618"
How can I specify this export layout in the export wizard?
Here's my problem. We maintain a list of items that are sold on ebay. We keep track of all items purchased by individuals and the dates that those items were purchased. We guarantee shipping by 6 weeks after the sell date...
Therefore, I am trying to create a query that will show me all items that are 6 weeks and older and have not shipped. There is a column that says date purchased and one for date shipped if an item is already completed. Any suggestions!!??!?! :confused:
Hi all,
I am generating a multi source concatenated code with an update query in Microsoft Access. I am wondering if there is a way to cut the update to only new entries rather than updating all records each time the query is run.
Any helpers for this problem?
Is it possible to query a field for special characters in a string? I want to find any records that have characters other than A-Z, 0-9
View 9 Replies View RelatedI am trying to run a query and display the results in a report (the report side of it is childs play and not a problem). The problem I am having is that I have a search form which should allow the user to search any one of 6 fields (text boxes) or a combination of each.
If the user enters something into a field then that search criteria must match. I wanted to have it so if all fields are left blank then it will show all entries in the database (but it isn't, it shows a blank report). I also wanted it to allow partial completion of boxes.
So for instance if I have 5 customers (Jones, Jonson, Jonus, jimjonkins, Janis) and I type "Jon" into the name field then I would like it to show the first 4 records as they all contain "jon" somewhere in their name but its not, its only allowing exact matches.
I currently have '[forms]![Search_Customer]![Search_Name]'.
I am trying to run a simple update query to copy data from one column (Addrl1)to another column (Working_Addrl1) within the same file and I can't for the life of me figure it out. Then I need to repeat for addrl2 and addrl3 to working_addrl2 and working_addrl3.
View 7 Replies View RelatedI have created a cross tab to extract pipeline and sales for Q1 2014, Q2 2014, Q3 2014 & Q4 2014... the user can select the quater from a multivalued text box...
Now for the final output, have created another query which pull the above four quarter in each column from the cross tab...now the problem arises when i change the quarter to Q2 2014, Q3 2014, Q4 2014 & Q1 2014..it gives an error "Microsoft office Access database does not recognizes "Query name" as a valid field name or expression".
The error is because the second layer of query does not identifies Q1 2014.
How do i make access change the column automatically when the Q1 changes to Q2...
I am looking to add a column in a query that will give a Y or No to previous column data if it contains TEXT or NUMBER (It could read "TEXT" or "NUMBER" or even Y for text or N for number).
View 3 Replies View RelatedHello
Im new to access and really need some help please.
I have a table with column headings i need to split up but dont know how to write it in code.
i want to split AA: Austrailia 1-3Years into AA and 1-3
i then want to compare both those string to another table and allocate a number in a further table. does that make sense?
please help!
many thanks
Hi,
Was wondering whether its possible to control the appearance of pages...
I have a main form on which I have about 7 pages. When the main form is in the FORM-view, the headings of the pages are 'hidden'. One has to scroll up in order to see them.
As certain users of the database will be using Access viewer and thus only see this main form, it would be convenient if I could make sure that when the MAIN form is on, the headings are not hidden. So, it's a layout problem.
Any tips on this?
Thanx Stacey
Is there a way of formatting the caption used for the heading (page descriptions) for the different tabs on a tabbed form? I would like to make them bigger/bold. I thought there would be a property that would let me make changes. Probably a simple thing I am missing.
Thanks.