Query3
  Home FAQ Contact Sign in
 
Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...

found 185 articles for 0.305 sec
On 21 Set, 20:48, "filip...@hotmail.com" <filip...@hotmail.com> wrote: > On 21 Set, 20:41, "Cinzia" <cinziapagani-no-spam_ple...@tiscali.it> > wrote: > > > > > <filip...@hotmail.com> ha scritto nel messaggionews:cd1d188b-3b1b-4823-bbf1-b9408bccc106@z66g2000hsc.googlegroups.com... > > Salve a tutti riporto in seguito il codice che non funziona sperando > > che qualcuno sappia il motivo. >     

Group: it.comp.appl.access · Group Profile · Search for Query3 in it.comp.appl.access
Author: filiprat
Date: Sep 21, 2008 11:52

On 21 Set, 20:41, "Cinzia" <cinziapagani-no-spam_ple...@tiscali.it> wrote: <filip...@hotmail.com> ha scritto nel messaggionews:cd1d188b-3b1b-4823-bbf1-b9408bccc106@z66g2000hsc.googlegroups.com... Salve a tutti riporto in seguito il codice che non funziona sperando che qualcuno sappia il motivo.     Dim rst1 As ADODB.Recordset     Dim str1 As String     str1 = "SELECT Query3.c_prodotto
Show full article (2.68Kb) · Show article thread
<filiprat@hotmail.com> ha scritto nel messaggio news:cd1d188b-3b1b-4823-bbf1-b9408bccc106@z66g2000hsc.googlegroups.com... Salve a tutti riporto in seguito il codice che non funziona sperando che qualcuno sappia il motivo. Dim rst1 As ADODB.Recordset Dim str1 As String str1 = "SELECT Query3.c_prodotto AS codice, Query2.descrizione, " & _ "Query3.n_commessa, Query3.n_settimana     

Group: it.comp.appl.access · Group Profile · Search for Query3 in it.comp.appl.access
Author: filiprat
Date: Sep 21, 2008 11:48

Salve a tutti riporto in seguito il codice che non funziona sperando che qualcuno sappia il motivo. Dim rst1 As ADODB.Recordset Dim str1 As String str1 = "SELECT Query3.c_prodotto AS codice, Query2.descrizione, " & _ "Query3.n_commessa, Query3.n_settimana, Sum(Query2.importo_netto) AS SommaDiimporto_netto, " & _ "Sum(Query2.quantita) AS SommaDiquantita, Query2.n_progressivo
Show full article (2.32Kb) · Show article thread
Is there a field with the record numbers or are you talking about any 100,000 records at a time? -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Gastimore" wrote: > Hi I have a query that return long number of records(over 500000 records), i > want to write sub queries that will return a number of records that I > specify     

Group: it.comp.appl.access · Group Profile · Search for Query3 in it.comp.appl.access
Author: Cinzia
Date: Sep 21, 2008 11:41

Hello, I just have started using mysql++ on Fedora Core 9 with gcc-4.3.0 and have run into a first problem: I am simply storing a single datum with type "TIME" using mysqlpp::sql_time into a test table and querying it again which fails. My code: #include <string> #include <mysql++.h> #include <ssqls.h> sql_create_1(time_test,1,0, mysqlpp::sql_time, ptime) int main(
Show full article (1.92Kb) · Show article thread
I have tried that but the fields are actually date and time fields. Do you think that by running the query using code will speed it up? -- Cheers "Michel Walsh" wrote: > You can use the operator BETWEEN, in the criteria line, under the field you > test: > > > > BETWEEN [start date] AND [end date] > > > Vanderghast, Access MVP > > > "Cadburys" <Cadburys@discussions     

Group: it.comp.appl.access · Group Profile · Search for Query3 in it.comp.appl.access
Author: filiprat
Date: Sep 21, 2008 11:21

Thanks. I have a another questions - I have 15 conditions to tests for - these include 5 different date fields which are searched for using a = start date and <= end date. How would I structure these? -- Cheers and thank you for your help! "Tom van Stiphout" wrote: On Thu, 18 Sep 2008 06:13:01 -0700, Cadburys <Cadburys@discussions.microsoft.com> wrote: ALL queries based
Show full article (1.47Kb)
On Thu, 18 Sep 2008 06:13:01 -0700, Cadburys <Cadburys@discussions.microsoft.com> wrote: ALL queries based on queries can be written as a single query. We use multiple queries to avoid the complexities of writing a single one, but we don't go overboard and write a new one for each simple step. It's up to you to find that happy medium. To your specific question, if I understand correctly     

Group: microsoft.public.access.queries · Group Profile · Search for Query3 in microsoft.public.access.queries
Author: Jerry Whittle
Date: Sep 19, 2008 09:04

Show full article (0.58Kb) · Show article thread
    

Group: mailing.database.mysqlplusplus · Group Profile · Search for Query3 in mailing.database.mysqlplusplus
Author: lists
Date: Sep 18, 2008 23:59

Show full article (1.85Kb)
    

Group: microsoft.public.access.queries · Group Profile · Search for Query3 in microsoft.public.access.queries
Author: Gastimore
Date: Sep 18, 2008 22:14

Show full article (0.34Kb)
    

Group: microsoft.public.access.queries · Group Profile · Search for Query3 in microsoft.public.access.queries
Author: Cadburys
Date: Sep 18, 2008 13:01

Show full article (2.83Kb) · Show article thread
    

Group: microsoft.public.access.queries · Group Profile · Search for Query3 in microsoft.public.access.queries
Author: Cadburys
Date: Sep 18, 2008 09:15

Show full article (2.13Kb) · Show article thread
    

Group: microsoft.public.access.queries · Group Profile · Search for Query3 in microsoft.public.access.queries
Author: Tom van Stiphout
Date: Sep 18, 2008 07:16

Show full article (1.75Kb) · Show article thread
1 · 2 · 3 · 4 · 5 · 6 · 7 · 8 · 9 · next