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
Count records within a range of values by Steve
Please help me. I have a table with fields Salesman, Customer, Comparison(% of sales volume compared to last quarter). I would like a query that gives the...
May 25th, 2004 01:16 PM
by Michel Walsh Go to last post
1 555
Better Example of Count() Query by Gary B
MASTER Table: CHARGES Fields: ChargesKey, ChargesDate Data: Row1 = 1, 05/25/2004 DETAIL Table: SERVICES Fields: ServicesKey, ChargesKey, ServicesDate,...
May 25th, 2004 01:44 PM
by Michel Walsh Go to last post
1 269
can save the follwing queries by Jonas
Hi if I try saving the flowwing query access 2k crashes: SELECT CAPTIONS.Key, CAPTIONS.Translation FROM CAPTIONS, (SELECT ALanguage.ActiveLanguage AS...
May 25th, 2004 02:36 PM
by Jonas Go to last post
0 362
Getting and setting information by Jonas
Hi I have one important question: It so so easy to make powerful and fast queries on an access db, but how can I write data more easily in a certain bd...
May 25th, 2004 02:44 PM
by Jonas Go to last post
0 436
Access 2000 command buttons by JKA
When I use the command button wizard to create any command like "save" or "new record", I get the following error. " The expression On Click you entered as the...
May 25th, 2004 02:59 PM
by Rick Brandt Go to last post
1 355
Reminders by Tara
I'm not sure I'm posting this in the right spot, but here goes...I would like to design something to remind users to run a certain report every thirty days. ...
May 25th, 2004 03:16 PM
by Tara Go to last post
0 330
Help with simple query! by v_roma
Hi everyone, I've been trying to figure out how to do this query. I have a table and let's say it has three fields: site name, type of measurement,...
May 25th, 2004 03:24 PM
by Go to last post
3 465
Appending Weekly Sales to a table by ChuckW
Hi, I have a table of 2004 sales and need to create a report of weekly sales for the year. The data is stored in a table called 2004Sales which is constantly...
May 25th, 2004 04:44 PM
by ChuckW Go to last post
0 565
combo box has repeating options by Jennifer
I was not aware of the "NotInList" event, and have scratched the query that I mentioned before. I have tried finding the code example through Access HELP,...
May 25th, 2004 05:31 PM
by Go to last post
6 557
add column by Dan
is there a way to add columns in a query for example Loan officer # Loans Dan 2 Ed 3 Frank ...
May 25th, 2004 05:53 PM
by Lynn Trapp Go to last post
1 275
To: Allen Browne changing date format in query by
Hi Allen. Thanks for your help. In my query, I want to search between two date fields that are formatted dd/mm/yyyy using the date field that is formatted...
May 25th, 2004 06:00 PM
by Allen Browne Go to last post
1 489
Text in IIf(,,) expression in query by KaiRich
Hi all, I have four fields, if any of them hold "Y" then I want the query to return "Y" - but I only want one such field in the query. I have tried: EMP:...
May 25th, 2004 06:19 PM
by Ragnar Midtskogen Go to last post
2 319
Reports from Cross-Tab Queries by Jack
My cross-tab querie now works O.K. when passing parameters via the Query|Parameters route. And, of course, I can print the query results. But I want to do a...
May 25th, 2004 06:42 PM
by Duane Hookom Go to last post
1 437
Extract data by Tony
I'll give it a whirl. Thank you very much John. Tony "John Spencer (MVP)" wrote in message ... ...
May 25th, 2004 07:01 PM
by Tony Go to last post
1 315
Excel vs Acess by hermie
How can I implement the Excel COUNTA function in an Access query? herman
May 25th, 2004 07:40 PM
by Michael Hopwood Go to last post
1 286
trouble with query by Gary B
MASTER Table: CHARGES Fields: ChargesKey, ChargesDate DETAIL Table: SERVICES Fields: ServicesKey, ServicesDate, SalesRep I need to return the Count of...
May 25th, 2004 08:25 PM
by John Spencer (MVP) Go to last post
4 355
ODBC CALL FAILED by bikermike
When we try to run a query that passes a date variable we encounter "ODBC CALL FAILED". This is not happening on all our computers but we can't seem to isolate...
May 25th, 2004 08:58 PM
by John Spencer (MVP) Go to last post
2 734
Count Unique Values by AHopper
The following query "SixDifinPackagedUniqueQuery", using fields "JobNumber" and "UniqueLabelPack" from table "SixDifinPackaged" gives me a list of unique...
May 26th, 2004 12:05 AM
by AHopper Go to last post
6 682
Delete Record Based on Text Box by James Stephens
I have set this up to work before with one text box, but I am struggling to make it work with 2. Is there a way to make a delete query that will delete any...
May 26th, 2004 12:56 AM
by Duane Hookom Go to last post
1 529
help with not so simple query by v_roma
I apologize for reposting my question. It's actually a follow-up question, which seems more complicated than the original. Once more, for the sake of...
May 26th, 2004 02:28 AM
by ChrisJ Go to last post
1 294
Post New Thread


Display Options
Showing threads 41 to 60 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 09:47 AM.


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