Search results

How do you link an Excel table with an Access table??

I would but she needs to enter vasts amount of information and her machine will only output to Excel! bummer

Great idea, thanks a lot Aprpillai.

Hello all, I have uploaded my co workers data from Excel into an Access table. However my co worker constantly updates that table in Excel after each testing she does. I ran a macro originally: "transfer spreadsheet" to transfer the excel data to an access table but my problem is that whenever...

Thanks guys

Any Thoughts?

Here it is: Sample ID Type SiO2 AL2O3 FE203 .... 01 Bulk 22 .12 100 01 Surface 18 .11 89 02 Bulk 21 .25 85 02 Surface 12 .45 77...

Right, but can you be more specific. Where am I making these changes in?: in the table, query, report...? Looked in all of them but can't find what you're talking about

Are you talking about within the report?? Confused

sorry tables didn't come out so well after typing in.....just starting out with these blogs...

I have report based off of a query. The report is coming out as shown: Sample ID Type SiO2 AL2O3 FE203 .... 01 Bulk 22 .12 100 01 Surface 18 .11 89 02 Bulk...

Great, Thanks guys.

Hey all, I have a query with several tables in a relationship: Table 1: Power Plant info, Table 2: Sales Rep info...and a couple others. I have a filter for the power plant name that is given by the user on another form. On a report I need to see certain controls from the Power plant table...

I'm new at Microsoft Access and need to know proper SQL syntax to perform operations. I use macros but sometimes they don't have what I need to do.... Is there any place that teaches you SQL syntax and functions online?? or at least has a list of operations of somet type?? thanks

My business has a certain number of "modules" in inventory. One table has module number, # of modules initially and other info. In a form, the warehouse employee needs to enter in the Module number and how many modules are outgoing to a plant which will be saved in another table. Say we have 12...

Hey, Thanks. That's a good idea. I was trying to use two different tables for the addresses but one will do. Thanks for the help on my first post!

I have a form where users need to enter in Address information with 7 different controls {Street, City, State...). One control on the form is to say whether it is a "mailing or shipping" address (in a drop down). At the end of the form I want to ask with a "Yes" or "No" button whether the...