Find Jobs
Hire Freelancers

Access Form db Query

max $5 USD

Closed
Posted about 21 years ago

max $5 USD

Paid on delivery
We have a form that has a list box and a query We need to Dynamically select the field and the string. We have SELECT [login to view URL], Parcels.County_ID, Parcels.Parcel_ID, [login to view URL], [login to view URL], [login to view URL] FROM Parcels WHERE ((([login to view URL]) Like "*" & [forms]![ListSearchForm]![string] & "*")); and this works to dynamically select the string criteria. We attempted to do the dynamic field SQl SELECT [login to view URL], Parcels.County_ID, Parcels.Parcel_ID, [login to view URL], [login to view URL], [login to view URL] FROM Parcels WHERE ((([Parcels].[forms]![ListSearchForm]![FieldToSearch]) Like "*" & [forms]![ListSearchForm]![string] & "*")); But this does not work. This is copied directly from the SQL view from Access ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. ## Platform Access 2K
Project ID: 2919419

About the project

18 proposals
Remote project
Active 21 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
18 freelancers are bidding on average $4 USD for this job
User Avatar
See private message.
$3.40 USD in 14 days
5.0 (552 reviews)
6.7
6.7
User Avatar
See private message.
$4.25 USD in 14 days
4.9 (49 reviews)
6.0
6.0
User Avatar
See private message.
$3.40 USD in 14 days
4.9 (215 reviews)
5.9
5.9
User Avatar
See private message.
$4.25 USD in 14 days
5.0 (39 reviews)
5.9
5.9
User Avatar
See private message.
$4.25 USD in 14 days
5.0 (75 reviews)
5.6
5.6
User Avatar
See private message.
$4.25 USD in 14 days
4.3 (24 reviews)
5.2
5.2
User Avatar
See private message.
$4.25 USD in 14 days
4.4 (29 reviews)
4.1
4.1
User Avatar
See private message.
$3.40 USD in 14 days
5.0 (19 reviews)
3.6
3.6
User Avatar
See private message.
$4.25 USD in 14 days
5.0 (4 reviews)
3.3
3.3
User Avatar
See private message.
$4.25 USD in 14 days
5.0 (1 review)
3.3
3.3
User Avatar
See private message.
$4.25 USD in 14 days
4.6 (28 reviews)
2.6
2.6
User Avatar
See private message.
$4.25 USD in 14 days
5.0 (18 reviews)
2.5
2.5
User Avatar
See private message.
$4.25 USD in 14 days
5.0 (2 reviews)
1.6
1.6
User Avatar
See private message.
$4.25 USD in 14 days
5.0 (1 review)
1.4
1.4
User Avatar
See private message.
$4.25 USD in 14 days
5.0 (2 reviews)
1.4
1.4
User Avatar
See private message.
$4.25 USD in 14 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$3.40 USD in 14 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$3.40 USD in 14 days
0.0 (1 review)
0.0
0.0
User Avatar
See private message.
$4.25 USD in 14 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
5.0
36
Member since Dec 11, 2002

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.