Search results
-
E
sql question on using "as"
thanks tehNellie! I just got the answer after a lot of trial and error. :) It is very similar to yours so thanks again My problem was the syntax and the fact that using INNER JOIN I need to work with a hierarchy of brackets.... I'm not realy sure what U mean by "normalised" but normal or not'... -
E
sql question on using "as"
it seems i needed something like this: SELECT Q0.formula FROM recepies AS Q0 INNER JOIN recepies AS Q1 ON Q0.formula=Q1.formula WHERE Q0.Ingredient='water' AND Q1.ingredient='dough' -
E
sql question on using "as"
if only it were that simple:).... Thanks for the answer but this way I will also get "tea" in the results since your query uses "OR". I know I should be using "AS" and "inner join" to intersect 2 queries but i cant seem to get the syntax to work... -
E
sql question on using "as"
Hi all This should be simple enough but I cant seem to get it to work :confused: Lets say I have a table "recepies" | Formula | Ingredient | //these are the fields' names ---------------------------------- | cake | water | | cake | flour | |... -
E
delete a character in a string from a specific position
thanks - this should do the work.... Not very elegant but does the job! :) -
E
delete a character in a string from a specific position
wouldnt this delete all the "l" characters and not just the third? -
E
delete a character in a string from a specific position
Hi all This is a ridiculous question but I cant seem to find an answer. I'm working with VB on Access 2007. In other programming languages I know I use strings as arrays. This doesnt seem to be the case here and it gives me a headache. let's say I want to delete the third character in the... -
E
lock fields in a form when showing old records
Thanx! That worked out great! -
E
lock fields in a form when showing old records
ok....I will try to be clearer I have a field for when the record is taken. For the purpose of this discussion lets say I want to lock all records older than 3 days. By 3 days I mean the most flexible definition (On Friday block Tuesday and older) and not exactly 72 hours. The purpose is to let... -
E
lock fields in a form when showing old records
Hi I have a form which is used to take-in orders. The form is being used to add new records but also to edit records made in the last 2-3 days. I need to somehow not allow users to make changes to info in records older than that and only allow viewing of the info via the form. I coudlnt find...