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
Make Table Query takes long time by
I'm using a make table query to create a new table from Paradox tables. There are about 80,000 records in the Paradox tables and the process takes about 30...
May 25th, 2004 06:06 AM
by John Vinson Go to last post
1 662
Help to create databse by GabrielG
Hello everyone , I have a little issue to setup a database. I created a table with approximately 20 columns. The columns have an entry of Yes or no base on...
May 25th, 2004 05:29 AM
by Duane Hookom Go to last post
1 319
Dynamic Field Name in Query By Date by John Vinson
On Fri, 21 May 2004 02:09:55 -0500, Sakuraki wrote: Any...
May 25th, 2004 03:39 AM
by Duane Hookom Go to last post
2 584
Urgently need help with a database file!!!!!! by Shane
Good day. I really need some help! Someone here at our offices deleted a Access database file. I retrieved the file, but now it doesn't want to open!!!!!! It...
May 25th, 2004 03:30 AM
by Gary B Go to last post
2 479
changing date format in a query by Elisa
How do I change a date yyyymm to mm/dd/yyyy?
May 24th, 2004 10:01 PM
by John Vinson Go to last post
4 332
Query two fields into one combo box by JohnLute
tblCGStyles has two fields: txtCodeID (key) txtCorrugatedStyles cbStyle in my form queries both of these fields. How do I get the two fields to display in...
May 24th, 2004 08:57 PM
by Wayne Morgan Go to last post
2 553
Access Modules by Tausif Alam
Hi Guru, I need your help again. I like to call a access Module in access query. But it gives me error. Module: ----------- Function GetDatePart(pDate As...
May 24th, 2004 08:22 PM
by John Spencer (MVP) Go to last post
1 263
Object Names contains tidle (~) by Roddy
hi, Can anyone provide any information about the purpose or use of the tidle character (~) in object names, such as queries? Thanks, Roddy
May 24th, 2004 07:12 PM
by Roddy Go to last post
2 306
Change size of pop-up for parameter query by Rose
Is it possible to change the size of the pop-up that appears when you run a parameter query? I'd like to make the message longer than the allotted 37...
May 24th, 2004 06:24 PM
by Lynn Trapp Go to last post
1 355
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 856
'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 852
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 855
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 965
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 1,069
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 769
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 888
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 881
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 859
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 1,267
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 925
Post New Thread


Display Options
Showing threads 43261 to 43280 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 11:54 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.