Search results

I am trying ot pull information from Access into Excel using the query function. The query to pull the information from the Access database is the basis of the Excel query. The Access query pulls data in columns based on calculation fields for the 13 weeks of the quarter. When launched the...

Thanks, this worked great also.

Thanks this worked great!

Thanks for your help. Each of the responses were very insightful. I liked your response the best. However, I could not get the public function to run without an error.

I am looking for a way to combine fields in Access 2002 in an append query. I’m current using Table.Field1 & Table.Field2 and getting nothing close to what I need. Both fields are numeric. Field 1 is 4 characters in length and Field 2 is 1 to 4 characters in length. I want a new field of 8...