|
|
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...
|
|
1 |
678 |
|
|
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...
|
|
1 |
319 |
|
|
|
|
2 |
616 |
|
|
|
May 25th, 2004 03:30 AM
by Gary B
|
2 |
488 |
|
|
|
|
4 |
333 |
|
|
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...
|
|
2 |
583 |
|
|
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...
|
|
1 |
264 |
|
|
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
|
2 |
309 |
|
|
|
|
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
|
2 |
878 |
|
|
'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
|
2 |
882 |
|
|
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
|
1 |
879 |
|
|
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...
|
|
2 |
995 |
|
|
|
|
1 |
1,103 |
|
|
Using criteria by
Dave
I have a query with the following rows:
Pro1
Pro2
Pro3
Pro4
abc1
abc2
abc3
|
|
2 |
799 |
|
|
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...
|
|
8 |
913 |
|
|
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...
|
|
1 |
914 |
|
|
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...
|
|
1 |
884 |
|
|
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...
|
|
1 |
1,305 |
|
|
|
|
1 |
949 |