Search results

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...

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 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...

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...

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...

sorry, I should have been clearer I am trying to have 2 columns that will each combine 2 fields from 2 different tables

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

great thanks tha tworked

oh, I wasn't using sql, I was just typing it in the field section under design view

Thank you but it says query needs at least one destination field

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!

Thank you, I think the sub report is what I was trying to describe, I'll read into that more!

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

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...

sorry, I don't follow

Hi guys, I just created my first database with a lot of help from this forum and google, and I am pretty happy with it... now I would like to add something that will make it very useful for the audience... (let me know if i'm just being crazy and I'll give up on the idea) but here it goes We...

Thanks a lot Galaxiom, your answers are greatly appreciated!!

hehe and I just tried DateAdd... even better... thanks a lot! I guess my last question is how do I reference that newly created column... let's say I've created newfield and I want to use that for another formula so I have targetdate and newfield but I want it to only show customers that are...

Thank you that works, I will research the DateAdd function

Thanks for the answer, that's what I had read as well... However, with a query, I don't know how to add another field based on the calculation, I would like a new column created in the report generated from the query to show the new column that will be the target date - 7 I also don't know the...