Digital Workshop

Welcome to the Digital Workshop Message Boards
It is currently December 22nd, 2024, 11:49 pm

All times are UTC [ DST ]




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: % notworking
PostPosted: November 20th, 2006, 12:01 pm 
Offline

Joined: January 23rd, 2006, 2:57 pm
Posts: 55
Location: Belfast
Opus: 9.5
OS: Win 7
System: i7 8G ram
I have a database linked to opus. In a query I have four fields linked to variables. Problem is when you look at the query again two of the four fields now have the variable greyed out. Also when searching, the % sign does not work.
Any thoughts.
Paul


For this message paulj has been thanked by : mackavi


Top
 Profile  
 
 Post subject: sorted
PostPosted: November 21st, 2006, 12:20 pm 
Offline

Joined: January 23rd, 2006, 2:57 pm
Posts: 55
Location: Belfast
Opus: 9.5
OS: Win 7
System: i7 8G ram
Its ok folks got got it sorted. Just added 2 new fields in access and deleted the ones cuasing the prob. Had the query set to 'equals to' instead of 'like' the % now works in the search.
Paul


For this message paulj has been thanked by : mackavi


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC [ DST ]


Who is online

Users browsing this forum: No registered users and 53 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group