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
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Running & Setting Up Queries Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Passing Multi-Select to a Query by LarryP
I sometimes need to pass the results from a multi-select list box to a query, e.g., "Apple" or "Orange" or "Grape" etc. I've done this before by writing a...
December 2nd, 2009 07:10 PM
by LarryP Go to last post
0 189
Passing Multi-Select to a Query by LarryP
I sometimes need to pass the results from a multi-select list box to a query, e.g., "Apple" or "Orange" or "Grape" etc. I've done this before by writing a...
December 2nd, 2009 07:10 PM
by LarryP Go to last post
0 180
Help with: ...query that does not include specified expression ....as part of an aggregate function... by Need2Know
Good Afternoon, I keep getting "You tried to execute a query that does not include the specified expression '(Max(.)) Between . And .' as part of an aggregate...
December 2nd, 2009 06:06 PM
by Need2Know Go to last post
0 234
Help with: ...query that does not include specified expression ....as part of an aggregate function... by Need2Know
Good Afternoon, I keep getting "You tried to execute a query that does not include the specified expression '(Max(.)) Between . And .' as part of an aggregate...
December 2nd, 2009 06:06 PM
by Need2Know Go to last post
0 246
SHOWING MORE THAN ONE VALUE FIELD IN CROSSTAB QUERY by Kingsoft
I am atempting to use the crosstab query to display a series of data across various dates, but can only get one value field of data to work. Is there a way...
December 2nd, 2009 05:59 PM
by Kingsoft Go to last post
0 217
SHOWING MORE THAN ONE VALUE FIELD IN CROSSTAB QUERY by Kingsoft
I am atempting to use the crosstab query to display a series of data across various dates, but can only get one value field of data to work. Is there a way...
December 2nd, 2009 05:59 PM
by Kingsoft Go to last post
0 184
Query joins using and/or operators by KarenB
I don't know if this is possible in Access - I can do it in Crystal but haven't been able to figure out how in Access. I have two tables - one shows the...
(Multi-page thread 1 2 3)
December 2nd, 2009 05:50 PM
by KarenB Go to last post
21 557
Sum Only Subset Records Included in Max Sale Date by dallin
I have the following query: The sum(taxcredit) is not working -- it is summing all records by PED (period end date) where as I only want it to sum the...
December 2nd, 2009 05:45 PM
by dallin Go to last post
0 174
Sum Only Subset Records Included in Max Sale Date by dallin
I have the following query: The sum(taxcredit) is not working -- it is summing all records by PED (period end date) where as I only want it to sum the...
December 2nd, 2009 05:45 PM
by dallin Go to last post
0 220
queries written inside MS-Access are getting deleted by Harish
Some of the queries I have written inside MS-Access are getting deleted automatically. And while I run the queries through code, I get this error 'Query...
December 2nd, 2009 05:00 PM
by Harish Go to last post
0 194
queries written inside MS-Access are getting deleted by Harish
Some of the queries I have written inside MS-Access are getting deleted automatically. And while I run the queries through code, I get this error 'Query...
December 2nd, 2009 05:00 PM
by Harish Go to last post
0 202
Unable to bring back all results from table with query by Karrot_Bex
For a uni assignment we have a designated query that we have to create. But when I run the query, I get one result returned to me. I should have two returned...
December 2nd, 2009 04:43 PM
by Jerry Whittle Go to last post
3 173
Unable to bring back all results from table with query by Karrot_Bex
For a uni assignment we have a designated query that we have to create. But when I run the query, I get one result returned to me. I should have two returned...
December 2nd, 2009 04:13 PM
by Karrot_Bex Go to last post
0 176
Unable to bring back all results from table with query by Karrot_Bex
For a uni assignment we have a designated query that we have to create. But when I run the query, I get one result returned to me. I should have two returned...
December 2nd, 2009 04:13 PM
by Karrot_Bex Go to last post
0 172
Export query to Excel with formated heading by Song Su[_4_]
When export from query to Excel, I'd like to turn some columns into heading row on top of Excel sheets how to turn this: LastName FirstName SID Section...
December 2nd, 2009 04:07 PM
by Song Su[_4_] Go to last post
6 195
'new record' grayed out in query by Mary
Hello friends, I recently added a calcuation field to a query (in Access 2007 in a file saved to be compatible to Access 2003), and it even works. But now,...
December 2nd, 2009 03:36 PM
by Jerry Whittle Go to last post
6 190
Select a query showing only selective post codes relating a relevant postal area by chedd via AccessMonster.com
Hi please could you help as i would like to run a query only selecting relevant post codes from my database. The post codes i would like to select are...
December 2nd, 2009 02:38 PM
by John Spencer Go to last post
3 218
YTD Subquery is not including December why? by jeromez
Hi Allen: I created a query with a subquery to sum the hours worked by period (i.e., month) and then YTD hours next to the month hours. However, it's not...
December 2nd, 2009 02:15 PM
by John Spencer Go to last post
5 239
Select a query showing only selective post codes relating a relevant postal area by chedd via AccessMonster.com
Hi please could you help as i would like to run a query only selecting relevant post codes from my database. The post codes i would like to select are...
December 2nd, 2009 01:19 PM
by chedd via AccessMonster.com Go to last post
0 163
Select a query showing only selective post codes relating a relevant postal area by chedd via AccessMonster.com
Hi please could you help as i would like to run a query only selecting relevant post codes from my database. The post codes i would like to select are...
December 2nd, 2009 01:19 PM
by chedd via AccessMonster.com Go to last post
0 218
Post New Thread


Display Options
Showing threads 2081 to 2100 of 43289
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
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


All times are GMT +1. The time now is 05:46 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.