Search results

I am using the following code to try and update a group of queries that all start with qryBB. It works when I use select queries and print out statements to print out any query results, but I just want to run the group of update queries, not show the user any screens or print out. Can anyone...

I have a DB with just tables, no forms. In a table I have 5 fields, Loc1, Loc 2, Loc3, Loc4, Loc5 which are text fields. I need to update into Seg1, Seg2,...which will be number fields. Problem is that Loc 1 can be 1 of 28 choices, as can Loc 2-5. Is there any way around doing 28 individual...

Think I got it, 1 table, both old and new in it, new has the lookup table, update query contains the table and the lookup table. Lookup table has the number field, and the text field. Link to the table on the text field and the old field, update to the new number field, right?

Forgive me for not understanding, but do you create 2 tables, one with the old data (in my case the text values) and another table with the new fields formatted to what I need (numbers)? Then join these two together on the primary key (which is the same) and do the update query? I tried this...

I created another table with the formatting I wanted for the fields in that, then used an append query to bring in the information. That worked fine.

Thanks, perfect.

RV - Is there somewhere in my query statement below that I could use the CInt function and then append it into a premade table where that field would be formatted to integer? Gender: IIf([Gender]="Male",0,1)

No. I have a table with many fields that are text. Through a make table query I am taking the fields I need and exporting them into a new database. This new database will be created each month, the information sent to someone else, then destroyed. The someone else needs the information for...

Ken, That would be OK if the information was already in 0,1 format and I just needed to change it to numeric then append it to a table where the field would be numeric, but I have to convert the Male to 0 before I append it, and NOT do that to the table it's coming from, just in the query. RV -...

Maybe I am going about this the wrong way. I have a table that has data mostly in text format. I do a make table query from that data and create a table in a new database that still has that data as text. I run an update query to change, for instance, "Male" to 0 and then use the CInt...

I have a table with imported text fields that need to be changed to number fields. I used the CInt function in an update query to change "Male" into 0. Question is, in the table design view, the field still reads as type text. I will need to do calculations on these numbers, can you tell me...

Could someone tell me the code for a function that will look at Gender from the demographics table and update it in the table to a 0 if it = "Male" or a 1 if it = "Female". Thanks in advance.

I have used a make table query to create a table with text values. I need to convert these values to numerical data, for instance "Male" should become 1 and "Female" should become 0. I tried doing this in an update query, but had to use 2 separate queries. Don't know if a macro would work to...

I need to use the make table queries as I am making another database from the one I am generating the queries from. Is there any way at all to get the formatting to go thru to the new tables using a make table query? What syntax would I use specifically in the query to format the SSN? Thanks.

I have data coming from a table using an input mask for the social security number. It then goes into a query and is formatted perfectly in that query as a select query. I then change it to a make table query and have it make a table outside the current database, and in that new table the...

Yes, that worked perfectly! Thanks!

My report shows the department and number of cases it handled. No detail section is used. The number of cases is an unbound text box using the count function. Is there a way that I can sort the records so the units with the most "counted" cases show up first, from highest number of cases to...

We figured it out! What had happened was someone typed in "Whatever and then several spaces (inadvertantly I hope) then Whatever" again. So it would be like Whatever Whatever. In the table you could NOT see the second Whatever, so you thought you had typed in the name correctly and if...

I have a tbl w/ UserID, LName, FName, etc. When I try to use Find to find the last name "Whatever" for a particular record, it will NOT locate it, although it will locate the ID number and/or First name of that record. Not a typo on the last name either, so ????? All other records work fine...

Adding a list box to this code I used the post above to create the code below, which works fine for the user. What she would like, however, is to be able to look at the list box that resides on the form now (lstPatient) which contains a number of fields that could potentially identify a...