Search results for query: *

if i want to export data from access into sheet 2 of an excel spreadsheet is there a specific address for it like c://office\excel\book1.xls\sheet2 THis is possible for me as long as sheet 2 has an address bc i need to specificy an output location. ?? THanks!

I am want the results of 3 queries in Access to be exported into the same spreadhseet on 3 different sheets in Excel. I have set up a macro that can run the queries and then output them to this specific excel file but if i want to get the other two one it just replaces the whole file with the...

thanks so much for your help0. that one works but the update query for the other one just deletes the cells i was going by this: UPDATE TO: =Mid(yourField,2) CRITERIA: '<*' do i need to change this one?

Thanks for the reply but I just deleted the S and tried it again andit says "Invalid procedure call" I'd like to do it like this and avoid using VBA bc I am not familiar with that unless you could explain it. So I just tried this: Field: Quarter Table: Table1 Update to...

Thanks PH I need to do it in an automated matter with constant new data so this is what I am looking for however it does not work. My column name is quarter. anf my table name is Table1 I wrote the followin in an update query Field: Quarter Table: Table1 Update to...

i have a column in a table that reads quarter and is supposed to have data in the following format 04 Q4 05 Q1 03 Q2 However, some of these have <> signs on them by mistake and i want to get them off. How do I make an update query to find the signs and just delete them. They are only before or...

thanks for the reply, sp basicxally i have to create a template in excel - but export the access data to a different file in excel and then cut and paste that excel data into my template? I don't know code so is this my best option?

I am exporting data to Excel from a Macro I created in Access. Everytime I export the report, query, or table it rewrites the file or basically replaces it. For example the macro in Access is set to export to the Excel file called “TEST.xls” The problem is that I constantly import new raw data...

im not familiar with that, where do i find these subreports?

Is there a way to get information from various queries or tables into one report?

is it possible to pull single cell data from different areas and put it into one report? like one cell in a Cost column in table1 and one cell from purchases cell in table2?

My ultimate goal is to put all this data into a report the way I want to. SO I turned my different queries into make table queries and have been cutting and pasting them into one table which the report is based on. I need to do 2 things: 1- bring a bunch of rows from one table and have it placed...

I need to find a way to add information from one table to another, automatically how can I do this? Thanks!