Recent content by Indep99
-
I
Query to Replace headers
Thanks guys but this is the situation for example the generic table has tag1 tag2 tag3 as headers and let's say this year tag1 could be location, tag2 could be name and tag3 could be dollars but next year the tags can change and therefore the names will be different. I wanted to set up a table... -
I
Query to Replace headers
sorry I meant headers are the field name... the system generates generic field names for each column I can do the set as but there are 40 columns and I wanted to automate it somehow... so that it looks for field name x and based ona different table returns the value x = hello -
I
Query to Replace headers
I am creating a query in Access that extracts data to an excel file, however the table in access has generic headers that are not understandable to users, as a result I wanted Access to replace the headers in the query with meaningful ones so that once it gets exported to Excel, users know... -
I
Query to Replace headers
Hi Sorry, it made sense until the end part... Here is my situation Table1 Headers: Field1 Field2 A Alpha B Beta Table2 Headers: A B 100 200 100 600 I want to extract the numbers from... -
I
Query to Replace headers
Hello, I have a linked table in Access that has generic names... I also have another table that matches each generic name to a full description name which lets the user know what the generic name means. I want to create a query that will bring out the values from the table but with the field... -
I
query to combine fields from two different taBLE
sorry, I should have been clearer I am trying to have 2 columns that will each combine 2 fields from 2 different tables -
I
query to combine fields from two different taBLE
SELECT [projectname] From [tbl_projects] Union All Select [programname] From [tbl_programs] Select [Subject] From [tbl_projects] Union All Select [Title] From [tbl_programs] one would work without the other but if I use both, i get syntax error in FROM clause -
I
query to combine fields from two different taBLE
great thanks tha tworked -
I
query to combine fields from two different taBLE
oh, I wasn't using sql, I was just typing it in the field section under design view -
I
query to combine fields from two different taBLE
Thank you but it says query needs at least one destination field -
I
query to combine fields from two different taBLE
Hi, I have two tables Table A has programs Table B has projects I want to create a query that will list all of the programs and projects in one column, is there a way to do this? Thanks! -
I
Report based on query will show multiple values
Thank you, I think the sub report is what I was trying to describe, I'll read into that more! -
I
combining columns but having "enter" between
Hi, I am trying to combine a few columns in a query but I would like it to the "enter" function added in between each column so for example A b c Text 1 text 2 text 3 result: Text 1 Text 2 Text 3 -
I
Report based on query will show multiple values
Hi, I have linked two tables together in a query that has one primary key (file #) and then a bunch of information (first name, last name, date of birth) then a second table (file # --> which is linked, status --> which are multiple) so these two tables are linked and the data comes out fine but...