Advertisement

03.19.2008 at 05:18AM PDT, ID: 23253246
[x]
Attachment Details

Can I Use a SQL query in Access Report Textbox

Asked by Crxfrd in Access Reports, Databases Miscellaneous, Microsoft Access Database

Tags: MS Access SQL

Hello,

I am building a report of daily total quantities delivered to customers by week

I want to format the report such that it reads across the page rather than down

IE

Week Number
                                     Mon         Tue       Wed       Thu       Fri

     Customer1               100           73        250        12        21    Total: 456
     Customer2                 25           25          25        25        25    Total: 125

I have a query that contains all the data for 2008

Can I insert a sql query in a text box so that it only returns the total for customer 1 for Monday for week number n?

If this is possible are there any specila syntax issues I need to be aware of?

THank you

Start Free Trial
[+][-]03.19.2008 at 06:18AM PDT, ID: 21161141

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.19.2008 at 06:19AM PDT, ID: 21161161

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Access Reports, Databases Miscellaneous, Microsoft Access Database
Tags: MS Access SQL
Sign Up Now!
Solution Provided By: clarkscott
Participating Experts: 3
Solution Grade: A
 
 
[+][-]03.19.2008 at 07:57AM PDT, ID: 21162200

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]03.19.2008 at 11:08AM PDT, ID: 21164112

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.19.2008 at 02:03PM PDT, ID: 21165873

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.20.2008 at 06:12AM PDT, ID: 21170939

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.20.2008 at 06:19AM PDT, ID: 21171014

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.20.2008 at 06:25AM PDT, ID: 21171096

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628