473,404 Members | 2,213 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,404 software developers and data experts.

Why this query does not work in my program but in Access works?

Expand|Select|Wrap|Line Numbers
  1. PARAMETERS [Param_Name] Text(255);
  2. SELECT TOP 1 * FROM (SELECT PHAII01.CUSTID AS ID, PHACU.LNAME & ', ' & PHACU.FNAME AS NAME, PHAII01.Date
  3. FROM PHAII01 LEFT JOIN PHACU ON PHAII01.CUSTID = PHACU.CUSTID
  4. WHERE (((RTrim([PHACU].[LNAME]) & ' ' & RTrim([PHACU].[FNAME])) LIKE '%' & [Param_Name] & '%'))
  5. ORDER BY PHAII01.Date DESC);
  6.  
Sep 20 '10 #1
1 1079
jimatqsi
1,271 Expert 1GB
What is your program? What do you mean by "my program" versus "in Access?" Do you mean you are trying to use this query string in VBA code and it doesn't work? If so, give us a look at your code.

In what way does it not work? What happens?

Jim
Sep 21 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Wayne | last post by:
I've found a few posts on this subject but no reason for the behaviour. Is there any logical reason that Docmd.Requery "MyControl" won't work under Access 2K but Me.Requery.MyControl will? Is...
12
by: Bookreader | last post by:
I tried Googling this but I get a whole lot of replies about running the SQL statement in VB via ADO. All I want to do is run an existing ACCESS 2000 query from VB with no information returned...
96
by: Karen Hill | last post by:
SELECT surgeries.*, animals.* FROM surgeries INNER JOIN animals ON .=. AND WHERE ((.=Date()) Or .=Date()); I'm trying to write a query that joins two table together, animals and surgeries...
2
by: RadiationX | last post by:
How does this program work? // fig06_07.c -- COP2220 Example -- 040209 (sjd) // Student poll program #include <stdio.h> #include <stdlib.h> #define RESPONSE_SIZE 40 //...
2
by: ILCSP | last post by:
Hello, I have the following query in Access 2000 that I need to convert to SQL 2000: UPDATE tblShoes, tblBoxes SET tblShoes.Laces1 = Null WHERE (((tblShoes.ShoesID)=Int(.)) AND...
5
by: Allen | last post by:
I wrote many classes. In a class, there is a member variable which is declared as char szMTreeBuf. On both Windows XP and VxWorks, it cannot work. Then I try to declare the member variable as...
3
by: XavierX | last post by:
Hi, I am trying to create a web page that outputs a list of data from a join on 2 tables. The Tables: PANEL - A list of possible panel numbers PANELID - Primary key, EVENTS - List of...
11
by: howa | last post by:
#include<iostream> using namespace std; int main(int argc, char* argv) { cout<<sizeof(argv) / sizeof(argv) ; return 0; };
19
by: Tim Marshall | last post by:
Hi everyone, I have an acquaintance who is doing some A2003 development who was asking a question on another forum (not a technical one) about an SQL problem he's having. As far as I can...
7
ollyb303
by: ollyb303 | last post by:
Hi, I am having a bit of a problem with TransferText macro. I am using TransferText, Export Delimited (no field names) to export the results of a query as a .csv file. The query is based on...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.