ACCESS FEED: Re: [MS_AccessPros] Re: Create table from query issue

Rabu, 09 September 2015

Re: [MS_AccessPros] Re: Create table from query issue

Thank you Crystal. I will play around with my application using byour suggestions.

Best Regards,

Greg

On Tuesday, September 8, 2015 5:16 PM, "crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

adding on ... you do not have to show series on a secondary axis if the scale is the same. Just make sure the RowSource is:

SELECT x-value, y-value1, y-value2 (, y-value3 ...)
FROM ...

warm regards,
crystal

How To Make a Graph with Microsoft Access (cc)
http://www.youtube.com/watch?v=YhgNX6BWWmk&list=PLis0tV85b5t6TuFPTldPF-Ra67As6-Rj0
- Create chart, change what data is displayed including formatting, chart type, titles and legend

~ have an awesome day

On 9/8/2015 6:08 PM, crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals] wrote:

Hi Greg,

> "having trouble adding multiple series into an Access Chart"

as Duane says, first make sure the query/SQL shows what you want

then, to put a series on another axis:

- go into design view
- double click on chart object to edit it
- right-click the series you wish to move and choose "Format Data Series"
- on the "Axis" tab of the dialog box --> Plot Series on "Secondary Axis" (instead of "Primary Axis")

warm regards,
crystal

Microsoft MVP Virtual Conference 2015 -- Access Web Apps, linking to SQL Azure from Access desktop, Excel workbook, and SSMS (53 minutes)
https://channel9.msdn.com/events/MVP-Virtual-Conference/MVP-Virtual-Conference-Americas-2015/CONS2-Using-Access-and-SharePoint-for-Travel-Expenses-and-Pulling-up-Maps

~ be awesome today ~

On 9/8/2015 3:52 PM, Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] wrote:

Greg,
The data displayed in an Access chart is based on the chart's Row Source property. If the datasheet view of the Row Source doesn't display what you expect, then it won't display properly in your chart.

Can you provide the SQL view of the Row Source and suggest what you expect to use for x & y axis as well as the series?

Duane Hookom, MVP
MS Access

From: MS_Access_Professionals@yahoogroups.com
To: MS_Access_Professionals@yahoogroups.com
Date: Tue, 8 Sep 2015 21:11:36 +0000
Subject: Re: [MS_AccessPros] Re: Create table from query issue

Hi Crystal,

I am having trouble adding multiple series into an Access Chart. Can you please help with a suggestion on how I can do this?

Thank You

Greg

On Friday, September 4, 2015 7:46 AM, "crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

you're welcome, Rod ;) ~ happy to help

warm regards,
crystal

How To Migrate Data from Desktop to Access App on the Web (cc) 32:35 video
https://www.youtube.com/watch?v=5joYQaj--08

~ have an awesome day ~

On 9/3/2015 9:00 PM, desertscroller@cox.net [MS_Access_Professionals] wrote:

Thanks John and Crystal, The suggestions did the trick. Another lesson well learned.
Rod

---In MS_Access_Professionals@yahoogroups.com, <strive4peace2008@...> wrote :

Hi Rod,

wrap your autonumber fields with cLng in the query and assign a new name

MyNewfieldname: cLng([AutonumberFieldname])

warm regards,
crystal

2015 Microsoft MVP Virtual Conference Presentation on Access Web Apps, and linking to SQL Azure from Access, Excel, and SSMS (53 minutes)
https://channel9.msdn.com/events/MVP-Virtual-Conference/MVP-Virtual-Conference-Americas-2015/CONS2-Using-Access-and-SharePoint-for-Travel-Expenses-and-Pulling-up-Maps

~ have an awesome day ~

On 9/2/2015 2:44 AM, John Viescas JohnV@... [MS_Access_Professionals] wrote:

Rod-

Two solutions:

1) Create your table ahead of time and then use an INSERT query.

2) Assuming there's a copy of AuditorID in the company table (should be Long Integer), use that instead of the AuditorID AutoNumber from the auditor table.

If you're still stuck, post the SQL of your query.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Sep 2, 2015, at 5:16 AM, desertscroller@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

I am currently trying to create a table from a query but have an issue. The problem is the query is extracting data from two tables and data includes autonumber fields from the two tables. The table will not allow multiple autonumber fields. Both fields are needed but not sure how to approach the issue. I need to filter the new table on one of the two fields.
One field is the id of a company and the other is the id of an auditor. I am looking at creating a name from the auditor table then filter on it. Will take extra coding.
Anyone have another approach that would simplify the process?
Access 2010 , Windows 10, 8.1 and 7

Rod