Search results

I created an Access database in 2003 format and have upgraded from windows xp and office 2003 to Windows 7 with Office 2010. I have a table (tblemployee) that is using a autonumber as a primary key. Everything has been working fine with it but when I upgraded I needed to add a new employee. I...

in the criteria area of your query in the date field <=date() should work. Tim

I think I've got it. checked against it and it seems to be good. Thank you very much for your help. SELECT * FROM (select Changes.ECN_Number As Prod, [ECN_Number] as Location from Changes Union All select Part_Number_1, [ECN_Number] from Changes Union All select Part_Number_2, [ECN_Number]...

I changed it to FROM (select Changes.Part_Number_1 As Prod, [ECN_Number] as Location from Changes and I get the error of my columns do not match. Assuming becuase there is 2 columns in the start and there are 3 in the union selects?

Sorry for the misunderstanding on the parens. Is it correct to put a , then the third? Getting 3 columns but only 2 )Product and Location so code will not run. Starting to get confused. SELECT * FROM (select Changes.Part_Number_1 As Prod, "ECN_Number" as Location from Changes Union All select...

If I understood you correctly I didn't see ecn_number in the where clause, I am now getting a syntax error in the from clause: SELECT *FROM (select Part_Number_1, "ECN_Number") from Changes Union All (select Part_Number_2, "ECN_Number") from Changes Union All (select Part_Number_3...

Sorry for the confusion. Here is the goal, put part number in, it then searches and tells me what ecn's (primary key/no duplicates) it finds the part number in. So if I type 415588 into the criteria box I would like it to look in all part number fields(in the Changes table) and return the ecn...

Ok, this got me very close. The location is telling me what field it found it in, what I really need to know is what the ecn_Number is. Prod location 415588 Part_Number_1 415588 Part_Number_1 Once again I am sorry for all the trouble. Tim

Ok, thanks again for the clarification. Sorry for being such a pain, never written a manual SQL before. No, the table is not normalized, when this was created with the dynamic field ability should have been created in exel where the lines are already there instead of hidding and unhiding fields...

Thanks for the help. I will give it a try tonight. I am a little confused what you mean by the naming conventions. The table this is named "Changes" and all of the fields are Part_Number_1 ... Do I need to change "from Table" to "From Changes" or do I need to refer to the "ECN_Number" field? Tim

I am now getting a error on my from statement. I put the first 10 records in as a test but the code will not run. I want all of the ECN numbers that have the part number loaded into the Part_Number_1 criteria. Do I need the from statement since it is only searching 1 table? Here is SQL that I am...

David, Thanks for the thought it is greatly appreciated and I will try it out tonight. Thanks again. Tim

Basically there is an area for 48 possible changes to 1 ecn number. They may make one change or 48. They want a lookup (find function) to find a specific part number in the table, it may be in field 1 or 48 and there may be times when a part number has changed mutiple times. So they would like...

I have a simple query to look at a table for a part number. There are 48 possible fields that the part number could be in. Can I make the criteria based on field 1 = to the other 47 fields? An example would be in Part_Number_1 criteria [Enter Part Number], in fields 2-48 criteria...

The database will always look up the primary key or unique value. If you want to display the information in colume 2 go to disign view and look at the colums cell and you should see something like 1;0. This is telling you that it is showing 1" width for colume 1 and 0" for colume 2. To fix this...

I have a table named tblProjectNumber that has a autonumber field. In design view under the format property I have "NC07-"00000, this returns the a new project number with the text in front of it. What I would really want is for the text the change dynamically with the year. So an example would...

Thanks Paul, I haven't had a chance to load it in but I really appreciate your help and quick responce. Tim

This information is typed directly into the criteria cell of the query?

I have a perameter query that tracks everyone's time on different projects. When they click on the command button to run the query they are asked for the current start data and end date (this is loaded into the date field within the query on the criteria cell). When they click on this query I...

If your Chart is based on a query all you have to do is go to the row source of the chart and open the query that supplies the information. In the date field (looking at design view) go to the criteria section and type Between [Enter Start Date] and [Enter End Date]. This will give you a message...