A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"Hold" values?



 
 
Thread Tools Display Modes
  #1  
Old May 24th, 2005, 09:21 PM
cottage6
external usenet poster
 
Posts: n/a
Default "Hold" values?

If possible I need to create a query with data from all 4 or 5 weeks in a
period, layed out in columns like a spreadsheet. Example:
W/E 2/5/05 W/E 2/12/05 W/E 2/19/05 W/E
2/26/05
Number Dollar Number Dollar Number Dollar
Number Dollar
1 $15 1 $5.97 4 $15.99
1 $40.00

The user runs this report by week, so what can I do to "capture" the week
ending dates, along with the number and dollar amounts so I can add each week
as I go along? The week ending dates are in a table joined to the table
containing the number and dollar fields. Thanks for any help I can get on
this!
  #2  
Old May 25th, 2005, 01:56 AM
Dale Fye
external usenet poster
 
Posts: n/a
Default

You're not going to be able to get a query to return results that look like
that, but you could get a report to do so. Create a query that returns
results that look like:

WeekEnding Number Dollar
2/5/05 1 15.00
2/5/05 2 xx.yy
2/12/05 1 5.97
2/19/05 1 40.00

Now create a report based on this query. Group it by WeekEnding, and put
the [WeekEnding] field in the Group Header. Then put the Number and Dollar
titles in the the Group Header as well. Finally, put the [Number] and
[Dollar] text columns in the detail section.

Then, select File-Page Setup, then select the columns tab and indicate the
number of columns you want, the spacing between the columns, the width of
the columns, etc.

You may find that you want a header on the Report, in which case, I would
recommend making the report we created above a subreport that you mount
inside a report that has the Title, Page number, Date printed, etc.

HTH
Dale
"cottage6" wrote in message
news
If possible I need to create a query with data from all 4 or 5 weeks in a
period, layed out in columns like a spreadsheet. Example:
W/E 2/5/05 W/E 2/12/05 W/E 2/19/05
W/E
2/26/05
Number Dollar Number Dollar Number Dollar
Number Dollar
1 $15 1 $5.97 4 $15.99
1 $40.00

The user runs this report by week, so what can I do to "capture" the week
ending dates, along with the number and dollar amounts so I can add each
week
as I go along? The week ending dates are in a table joined to the table
containing the number and dollar fields. Thanks for any help I can get on
this!



  #3  
Old May 25th, 2005, 01:35 PM
cottage6
external usenet poster
 
Posts: n/a
Default

Dale, thanks for getting back to me. I'm somewhat confused. Since the week
ending dates are in 1 field, when I prompt the user for W/E 02/05/05 to get
that data, the next time she runs the query for the next W/E date all the
numbers will change to reflect that date. Don't I need a way to store the
W/E 02/05 values?

"Dale Fye" wrote:

You're not going to be able to get a query to return results that look like
that, but you could get a report to do so. Create a query that returns
results that look like:

WeekEnding Number Dollar
2/5/05 1 15.00
2/5/05 2 xx.yy
2/12/05 1 5.97
2/19/05 1 40.00

Now create a report based on this query. Group it by WeekEnding, and put
the [WeekEnding] field in the Group Header. Then put the Number and Dollar
titles in the the Group Header as well. Finally, put the [Number] and
[Dollar] text columns in the detail section.

Then, select File-Page Setup, then select the columns tab and indicate the
number of columns you want, the spacing between the columns, the width of
the columns, etc.

You may find that you want a header on the Report, in which case, I would
recommend making the report we created above a subreport that you mount
inside a report that has the Title, Page number, Date printed, etc.

HTH
Dale
"cottage6" wrote in message
news
If possible I need to create a query with data from all 4 or 5 weeks in a
period, layed out in columns like a spreadsheet. Example:
W/E 2/5/05 W/E 2/12/05 W/E 2/19/05
W/E
2/26/05
Number Dollar Number Dollar Number Dollar
Number Dollar
1 $15 1 $5.97 4 $15.99
1 $40.00

The user runs this report by week, so what can I do to "capture" the week
ending dates, along with the number and dollar amounts so I can add each
week
as I go along? The week ending dates are in a table joined to the table
containing the number and dollar fields. Thanks for any help I can get on
this!




  #4  
Old May 25th, 2005, 05:28 PM
cottage6
external usenet poster
 
Posts: n/a
Default

Dale, never mind. I was making this a lot harder than it needed to be.
That's what inexperience will get you!

"cottage6" wrote:

Dale, thanks for getting back to me. I'm somewhat confused. Since the week
ending dates are in 1 field, when I prompt the user for W/E 02/05/05 to get
that data, the next time she runs the query for the next W/E date all the
numbers will change to reflect that date. Don't I need a way to store the
W/E 02/05 values?

"Dale Fye" wrote:

You're not going to be able to get a query to return results that look like
that, but you could get a report to do so. Create a query that returns
results that look like:

WeekEnding Number Dollar
2/5/05 1 15.00
2/5/05 2 xx.yy
2/12/05 1 5.97
2/19/05 1 40.00

Now create a report based on this query. Group it by WeekEnding, and put
the [WeekEnding] field in the Group Header. Then put the Number and Dollar
titles in the the Group Header as well. Finally, put the [Number] and
[Dollar] text columns in the detail section.

Then, select File-Page Setup, then select the columns tab and indicate the
number of columns you want, the spacing between the columns, the width of
the columns, etc.

You may find that you want a header on the Report, in which case, I would
recommend making the report we created above a subreport that you mount
inside a report that has the Title, Page number, Date printed, etc.

HTH
Dale
"cottage6" wrote in message
news
If possible I need to create a query with data from all 4 or 5 weeks in a
period, layed out in columns like a spreadsheet. Example:
W/E 2/5/05 W/E 2/12/05 W/E 2/19/05
W/E
2/26/05
Number Dollar Number Dollar Number Dollar
Number Dollar
1 $15 1 $5.97 4 $15.99
1 $40.00

The user runs this report by week, so what can I do to "capture" the week
ending dates, along with the number and dollar amounts so I can add each
week
as I go along? The week ending dates are in a table joined to the table
containing the number and dollar fields. Thanks for any help I can get on
this!




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to calculate values from 2 tables Luke Running & Setting Up Queries 2 December 9th, 2004 04:55 PM
average, eliminating zero values Chris Worksheet Functions 6 May 14th, 2004 11:36 PM
Look up values in one column based on values in another without repeating Frank Kabel Worksheet Functions 4 April 8th, 2004 10:54 PM
Look up values in one column based on values in another without repeating fbarbie Worksheet Functions 0 April 8th, 2004 09:38 PM
Formula cell references when sorting values in another worksheet Frank Kabel Worksheet Functions 0 March 30th, 2004 11:27 AM


All times are GMT +1. The time now is 08:03 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.