Search results

Hi! I have a query and I would like to add 2 columns that have fixed value. e.g. say if the query is select A into table 1 from table 2 The result is column A from table 2, but I would like the result to have 2 more columns with fixed value. so the result should be table 1 with 3 columns...

I have a query that gives me a table with one column, say column A. I need to add 2 columns to the table and the coulmns will have fixed value. So I need to add column B and column C to my table and all rows in column B will have a fixed value and all rows in column C will have a fixed value...

Thanks!! I wish I was as smart as you Bob! That worked.

Thanks for reply. When I try "Find Unmatched Query Wizard" Access says feature not installed. When I try to install, then it says missing SKU011.cab file. I am not supposed to post tables as it contains confidential information.

I have 2 tables. I would like to join the 2 and come up with a table that has records that is NOT in both tables.e.g. Table 1 has Field A with records 1,2,3,4,5 Table 2 has Field A with records 1,2,3,4,5,6,7 I want Table 3 to only have 6, 7. Sorry I am just a beginner. Any help will be...

THANKS!!! Update command works like a charm.

I usually send out thousands of records to another company for inquiry of some data (i wish i could get into details but I am not supposed to). Now this company wants the data or each records to be formatted in a certain way for them to run my data through an automated process and I get correct...

I have a field and in front of all records in this feild I would like to add a fixed text. e.g. if the record is XYZ i want to add abc in front to make it abcXYZ. Sorry newbie here. ThaNKS

Hi! I have a field that has to be 20 Characters long. Most of the time data for this field is less than 20 characters, so the remaining has to be filled with spaces to make it 20. e.g. if there is a record xyz1234567, then the rest of the record should have 10 spaces like xyz1234567ssssssssss...

I have joined 3 tables using the query design and I have 3 different fileds. There are fields that have information that I don't need. e.g. I don't want the first 10 characters of field 1. How do I do this in query design (even in SQL view). Or do I need to do this in the table itself before...