Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
 
 
Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
Old 06-21-2019, 11:50 AM   #1
rsingh4377
Newly Registered User
 
Join Date: Jun 2019
Posts: 39
Thanks: 9
Thanked 0 Times in 0 Posts
rsingh4377 is on a distinguished road
Access to Excel?

Hi, So I am trying to help add values to one database from another database. The origin of the data will come from a couple of tables on access and I am trying to input this information into an excel spreadsheet. However, the access data needs to be filtered before I transfer it to the spreadsheet. I am new to coding so I wanted to know if it was possible to filter the information with coding and then have this data inserted into excel? For example, I am trying to take a percentage from a couple of fields and divide this value by another field to get a percentage. So far I have this:
SELECT ((sum_quantity3+sum_quantity4)/(sum_total))*100
FROM ([tables]![bridge])
WHERE ([tables]![info]![Region]=1)
However, I am an amateur at coding so this may be entirely incorrect? Does it look like this would help me achieve what I am trying to do?

rsingh4377 is offline   Reply With Quote
 

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access to Excel to Iphone 6 Plus with Excel and back to Access Mike375 General 21 02-12-2016 08:27 PM
opens an excel file and copies values from access textboxes to excel cells deanvilar Modules & VBA 3 05-27-2013 08:27 AM
appending table in access from excel, excel file name change everyday with date gcgc2000 Queries 1 12-28-2012 04:21 PM
Import Excel workbook into Access table using Excel's format (formulas, values, etc) captdkl02 Modules & VBA 1 12-17-2012 09:03 AM
import multiple excel files with FILTERED Excel spreasheet into an access table WuJu Modules & VBA 5 10-31-2011 04:38 PM




All times are GMT -8. The time now is 05:58 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World