473,386 Members | 1,798 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,386 software developers and data experts.

How to convert a Access query to SQL..

SELECT ALL_Staff.ID, [Lastname] & ", " & [FirstName] AS FullName
FROM ALL_Staff
WHERE (((ALL_Staff.LastName) Like [forms]![ALLStaff_by_Alphabet]![txtLastNameFilter] & "*"))
ORDER BY [Lastname] & ", " & [FirstName];


Thanks a lot
Sep 16 '10 #1
3 1206
TheSmileyCoder
2,322 Expert Mod 2GB
Hi and welcome to BYTES

Im not really sure I understand what it is you want us to do?
Sep 16 '10 #2
haha, ok, you're right..I have a access database mdb, and now I am trying to migrate it to SQL, and run it throught access adp file.. Now most of the work is done.. I am stuck in one of the queries where the criteria set on the access old database dont fit with the new system (SQL- adp file) Criteria sent earlier, are those that I use in mdb file..So if you could help convert the same ones to apply for the adp file.. I hope i was clear enough ..
Sep 16 '10 #3
TheSmileyCoder
2,322 Expert Mod 2GB
I understand now. Afraid I can't help though, as I have no knowledge of Access and SQL server interaction. Im sure someone here can assist though.
Sep 16 '10 #4

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

Similar topics

3
by: FRITSCH Vincent | last post by:
Hi, i need help on a query. I've this table : create table t ( customer number(5), time date, status varchar2(1)
5
by: anthonyberet | last post by:
I work for an organisation that uses a bespoke document imaging system, the database of which is an MS sql server. We have MS Access and already use it for some querying of the database. The...
1
by: Nick | last post by:
Deear All, I would be thankful if you could help me with the following query. I have two tables TableA and TableB TableA Name: David Address: 123 West Side City: New York
3
by: John Fitzgerald | last post by:
Hi, I have the following two tables: 1. Client Table ID - Primary Key 2. Enrollment Table EnrollID - Primary Key ClientID - Foreign Key Enroll Date
1
by: The Pig | last post by:
Got a table like this. Name ID Location Bob 1 Home Frank 2 City Bob 1 Garden Jim 1 Outside I need a query that will go throught the table, identify when there...
8
by: s_wadhwa | last post by:
SELECT DISTINCTROW "01C" AS dummy, Buildings.BuildingNumber, UCASE(Buildings.BuildingName) AS BuildingName, Buildings.MasterPlanCode, Buildings.UniformBuildingCode,...
1
by: mountainbig | last post by:
Greetings! I have a table for for sales order with module information related to sales. i have a Module table with a list of modules. i am trying to create a query to pull all the sales...
1
by: shovan mohanty | last post by:
Hi , Can anybody convert below access query into equivalent stored procedure. Also please advice in the below query,user defined function of VBA i.e anneeSelection41510() has been used in the...
4
by: salserita | last post by:
Hi! This is my first question to the forum. I read the guidelines and will try to follow them as closely as possible. I have also searched past posts but was not able to find the specific answer to...
2
by: rahuldev999 | last post by:
Hi Can anyone please convert the below access query to the equivalent stored procedure.No problem with the IIF() function but the condition in the "where" clause making problem.so please put some...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
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: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
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?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
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...

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.