Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Microsoft query to export time card data into excel?

Posted By Jbo over 5 years ago

Can someone tell me what table/s I need to include to export the time card data for a job code using Microsoft query? When I select various tables thus far, no data is showing up. I know I can export the time card report to excel directly, but the data does not export in a user-friendly format and requires a lot of manipulation. Thanks, in advance, for your help!

Parents

0 BigLouie over 5 years ago

Here is how you figure it out. Open the report in designer mode and see what the work table is. Then go into Custom Office and try to add a UDF to that work table. Select the drop down for Data Source and it will list the tables that are read to go into building the works table. This will be the tables you need.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 BigLouie over 5 years ago

Here is how you figure it out. Open the report in designer mode and see what the work table is. Then go into Custom Office and try to add a UDF to that work table. Select the drop down for Data Source and it will list the tables that are read to go into building the works table. This will be the tables you need.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 Jbo over 5 years ago in reply to BigLouie

Hi BigLouie, I'm new to SAGE. Can you tell me how to open a report in designer mode?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

Microsoft query to export time card data into excel?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING