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
complex duplicate queries by Gary Walter
Hi Tony, I woke up this morning thinking about how you probably (might) want your queries to be updatable. One method is putting the group by in the Where...
May 23rd, 2004 12:19 PM
by Gary Walter Go to last post
0 591
"NOT EQUAL" query by Van T. Dinh
You got the Left Join wrong way around. The way you have at the moment, the Query will show Records in tblPersonnel that don't have related Records...
May 23rd, 2004 12:27 PM
by Chuck Go to last post
1 508
outlook express access to attachment by cathy
I received an email with attachment. Outlook Express blocked access to attachment to "suspicious email". What do I do to view attachment? Thank you for any...
May 23rd, 2004 02:50 PM
by Cheryl Fischer Go to last post
1 600
HELP: Update 1 table with calculated fields from another table by Samora
Hello I have a form who have 10 fields from TABLE1 that after make calculations with them i build the field M1 from TABLE2 The event that fires those...
May 23rd, 2004 05:16 PM
by Samora Go to last post
0 613
Between dates? by C & J Jones
"fredg" wrote in message ... On Sat, 22 May 2004 10:59:00 -0400, C & J Jones...
May 23rd, 2004 06:49 PM
by C & J Jones Go to last post
0 536
Dates In Queries by Roland Hanson
I have set up a query to add up some data. I used the wizard to set it up, I set the fields I wanted added, then it asked how I wanted my dates handled and I...
May 23rd, 2004 07:27 PM
by Steve Schapel Go to last post
1 563
I Can't Post by Al Voss
Although I can view, I can not post in most newsgroups. Please help. tia, al
May 23rd, 2004 07:36 PM
by Al Voss Go to last post
0 496
Can't Post Clarification by Al Voss
Now that my former post has gone through, when I am in other newsgroups using Outlook Express, I can view all ngs I visit. But I can't post in ANY of...
May 23rd, 2004 07:43 PM
by Al Voss Go to last post
0 534
Adding records to a query? by Mike J
I have a query attached to a form. On that form I have a combo box w/ a 'notinlist' event that is supposed to add a record if the 'id' is not in the list. I...
May 23rd, 2004 09:36 PM
by Mike J Go to last post
0 596
How to run an update query without cacheing ? by Todd Heiks
Hi- I have this suspicion that if I were to run an update query w/o cacheing an undo file, the whole thing would run faster. Does this sound reasonable? Is it...
May 23rd, 2004 10:41 PM
by Rickard Olsson Go to last post
1 418
Union Query Not Working Properly by JohnAFT
I am trying to use a Union Query to pull the top 2 records for each group from the same table. It works for the very first part (it pulls the 2...
May 24th, 2004 03:27 AM
by Van T. Dinh Go to last post
1 372
Date syntax in query by Ginger
I get an error message with the following sql statement. It does not seem to like the format "short date". Could someone check the syntax for me and see where...
May 24th, 2004 04:22 AM
by Duane Hookom Go to last post
1 360
Random Query? by Jenn
Access 97 I have three single digit feilds and would like to query on only two of them however, the data is accross all three fields. Exsample: Query for 34...
May 24th, 2004 04:55 AM
by John Vinson Go to last post
1 344
Date criteria syntax by Ginger
My last post did not appear, so here it is again. I get an error on the "short date" format. Any suggestions? sSQL = "TRANSFORM Sum(qryBillingSummary.Hrs) AS...
May 24th, 2004 06:33 AM
by Van T. Dinh Go to last post
8 367
Using criteria by Dave
I have a query with the following rows: Pro1 Pro2 Pro3 Pro4 abc1 abc2 abc3
May 24th, 2004 07:20 AM
by Andrew L. Go to last post
2 313
Creating empty date field with make-table query by Gary Walter
Hi TT, just in case "TT" 'tt' (other post) Another clever method Michel once demonstrated: NewField: IIf(True,Null,#1/1/1900#) -- you end up with...
May 24th, 2004 09:03 AM
by Nikos Yannacopoulos Go to last post
1 466
Display record based on current date by John H
I would like to select records that are valid based on todays date. In this case the records startdate and enddate need to be between todays date. My table...
May 24th, 2004 11:07 AM
by Douglas J. Steele Go to last post
2 348
show all invoice totals by Cheri
An invoice may have more than one item to it. Each item is entered individually under one invoice number. I just want a query to show the invoice total for...
May 24th, 2004 04:06 PM
by Rowan Go to last post
1 343
'Not in' Query by John
Hi, I have a few tables and want to run a query, but am not sure how the sql will work out. I have a table that has a list of students, and a results table...
May 24th, 2004 05:16 PM
by Newbie Go to last post
2 338
Query Quandries by Frank
i have a table, tblgeneral, that contains order information on customers, referenced by tblcustomer, what i am attempting to do is show how many unique...
May 24th, 2004 06:19 PM
by Frank Go to last post
2 333
Post New Thread

Display Options
Showing threads 1 to 20 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:52 PM.

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