Search results for query: *

Hi there, I used to use FoxPro2 (DOS) long long time ago (over 10 years ago) and find it a lot better than dBase 4 at the time. My preference was and still like the product a lot. I became an Access developer not by choice but by circumstance. You see, a lot of companies have Access in their...

Example CrossTab query: TRANSFORM Sum([tbl90707].[Amount]) AS Amount SELECT [NelNetRollUp].[Total], [NelNetRollUp].[SubTotal], [tblNelNetMapEdulinx].[Account], [tblNelNetMapEdulinx].[subAcct], [tbl90707].[Accpac], [tbl90707].[Description], [tblNelNetRollUpOrder].[RollUpOrder] FROM ((tbl90707...

Personally, I really like coding with VB6 because the door is wide open to ActiveX connections. Will it be worth my efforts to continue upgrading my skills with this coding idiom.

Hi, There is a discussion in the Access Reports forum on how to attach an ADO recordset to the Me.RecordSource property. So far attaching an ADO recordset to the RecordSource property doesn't seem possible in a regular report, it may be possible in ADP. This is because the Me.RecordSource...

Hi everyone, I have a query that is working perfectly except that some how my Access ALWAYS convert the ( into [ and add a period after the ] when I saved this query: Thus, please do me a big favor by paste the query below to your Access query and save it, then open it again to see if Access...

Hi, I have a SQL statement (as below) that works fine when run; however, after I save it and the next time I open the query, Access change the "(" to "[" and added an extra period (".") at the end. ????? why ???? Help please! SELECT B.GLM, A.Description, A.Accpac, A.Amount, A.Category...

Lower case = LCase Upper case = UCase Proper case = ?? Thanks.

Hi, I code a lot of Access queries manually, and sometimes the string can get pretty long, such as: TRANSFORM Sum([tbl90707].[Amount]) AS Amount SELECT [NelNetRollUp].[Total], [NelNetRollUp].[SubTotal], [tblNelNetMapEdulinx].[Account], [tblNelNetMapEdulinx].[subAcct], [tbl90707].[Accpac]...

Hi, In MS Access, we normally supply an Access SQL query in the Report_Open event such as: Private Sub Report_Open(Cancel As Integer) Me.RecordSource = "QryString" End Sub In VB6 and VB.NET, Crystal Reports etc, we can initiate an ADO object, fill the ADO recordset with records and...

I supposed joining a table plus creating a query "on the fly" as the proposed syntax below is not possible in Access. Does anyone know of a way to make this work? SELECT Table1.Field1 from Table1 INNER JOIN (select Table2.Field1 from Table2) ON Table1.Field1 =(select Table2.Field1 from...

Hi there, I used to be able to use function like this in my queries: Cstr(), Clng() etc. Then suddenly Access tells me compile error where time I run a query with these function(s) on. Is there something in the options I can set to restore this? Thanks.

Hi, I was wondering how some of you can paste the codes you wrote in a white window which got imbedded in the body of the messages. How do you do that? Thanks.

Here is my simple example TRANSFORM query: TRANSFORM sum(Table.Amount) as Amount SELECT table.field1, table.field2, etc ... From Table INNER JOIN TheOtherTable GROUP BY Table.field1, Table.field2 PIVOT ([Period] & [Year]) This query will return 2 columns with the names: 92004 (meaning...

By that I mean: First, I believe that SQL is a universal language, although different vendors can adapt the language and make some minor adjustments to it to better suite a particular development platform, i.e., Access, SQL server etc. When I code a query in Access, I may use Access SQL, as...

I am developing an Access database for a local Adult video store. So far I am the following tables: 1). Titles: this table list all the movie titles with an autonumber data type, along with the studio, media type and related data. 2). Stars: Actors and actresses found in each title (link to...