Re: hi there i need some help because im new to dba stuff
Originally posted by Chumpie999typla
Just looking at your code I think the error you are receiving is because there is no space between the GenData allias and the WHERE. Assuming that you cut and pasted your sql into your message.
tried that didnt work still gave me a error missing operator in query expression
Originally posted by axsprog
try the select part of the statement without the insert. Are you doing this through the query design?
well i guess i need to run a update statement, i was trying to find all of the records that had blank dob and then insert a statement to a text field. so the select without the insert would pointless unless i wanted to fix all of the records by copy and pasteing into the records in a query (3000+ records)
Not pintless - it is called divide and conquer, if a SQL statement does not work, you break it down bit by bit and see where it breaks.
Also copy and aste is not a solution as you know, but dao or ado would work
dim db as database
dim rst as recordset
set db = currentdb 'or you db path or odbc source
set rst = db.openrecordset (select statement here) 'in quotes
x = 0
do until rst.eof
If is null ([rst!myfield]) or [rst!myfield] = "" Then
rst!myfield = "My text here"
X = x + 1
msgbox "process complete. There were.." & x & "..records affected."