Input Text into fields with query

  • Thread starter Thread starter Kentucky5
  • Start date Start date
K

Kentucky5

I have two field in a table that I want to run a query and
automatically update the data. The first field I was it
to be totally blank not with a 0 which is what I get when
I say empty string, The second field I want to input the
text "Customer". I have tried everything and I either
get -1 or 0 in the fields.
 
It sounds as if you are trying to write string or character data to either a
Yes/No or Number field. Open your table in design view and check the
DataType for these fields.
 
UPDATE stiCust SET stiCust.Condition = [stiCust]!
[Condition]="", stiCust.User = [stiCust]![User]='Customer';
 
UPDATE stiCust SET stiCust.Condition = [stiCust]!
[Condition]="", stiCust.User = [stiCust]![User]='Customer';
 
I think you want

UPDATE stiCust SET stiCust.Condition = "", stiCust.User = 'Customer';


Kentucky5 said:
UPDATE stiCust SET stiCust.Condition = [stiCust]!
[Condition]="", stiCust.User = [stiCust]![User]='Customer';


-----Original Message-----
Post the SQL for the query you are trying to run.

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX





.
Click to expand...
Click to expand...
 
THANK YOU, That works perfectly! Thank you so much!



-----Original Message-----
I think you want

UPDATE stiCust SET stiCust.Condition = "", stiCust.User = 'Customer';


UPDATE stiCust SET stiCust.Condition = [stiCust]!
[Condition]="", stiCust.User = [stiCust]![User] ='Customer';


-----Original Message-----
Post the SQL for the query you are trying to run.

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


No, one field is a memo field and the other is a text
field.


-----Original Message-----
It sounds as if you are trying to write string or
character data to either a
Yes/No or Number field. Open your table in design view
and check the
DataType for these fields.

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


in message
I have two field in a table that I want to run a query
and
automatically update the data. The first field I was it
to be totally blank not with a 0 which is what I get
when
I say empty string, The second field I want to
Click to expand...
input
the
text "Customer". I have tried everything and I either
get -1 or 0 in the fields.


.



.
Click to expand...
Click to expand...


.
Click to expand...
 
Back
Top