•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 423,088 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,385 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser: Programming Forums
Views: 1261 | Replies: 2
 |
•
•
Join Date: Dec 2006
Posts: 3
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
How can you make a table from a union query in access - i have the union working and producing what i want but i can store it as a view or as a table - i keep getting syntax errors
the end result is i need to use the unioned data for a calculations
so if someone knows how to use a query for data creation instead of a table that would work also i think
INSERT INTO HgTotals SELECT CollectionDate,HgTotalnglA as AllHGtotal FROM HgPace UNION SELECT CollectionDate,HgTotalnglB as AllHGtotal FROM HgPace;
the end result is i need to use the unioned data for a calculations
so if someone knows how to use a query for data creation instead of a table that would work also i think
•
•
Join Date: Nov 2007
Location: Arkansas
Posts: 393
Reputation:
Rep Power: 2
Solved Threads: 76
Posting Whiz
Save the union query. Create a new create table query that uses the union you just created.
•
•
Join Date: Jan 2008
Posts: 29
Reputation:
Rep Power: 1
Solved Threads: 2
Light Poster
Why not just save the union query and use it in another query for your calculations just like using another query.
Bob Larson
____________________________________
Access MVP
For Quick Tutorials and Samples for Microsoft Access: BTAB Development
____________________________________
Access MVP
For Quick Tutorials and Samples for Microsoft Access: BTAB Development
|
•
•
•
•
•
•
•
•
DaniWeb MS Access and FileMaker Pro Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- Query logic (MS SQL)
- Retrieving duplicate consecutive records.(How to make query for this scenario?) (MS SQL)
- SQL String question (ASP)
- Query Help (MS SQL)
- Crystal Report 11 and Visual Basic 6.0 sql query.... (Visual Basic 4 / 5 / 6)
- Query multiple tables with duplicate data (MySQL)
- I want to let members message each other (PHP)
- Query multiple tables? (MySQL)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: Major help needed
- Next Thread: Command Button: Print Form - VBA code
