Search results

I have a computation in a query which results in numbers with extensive decimal places. I need to match the calculated values to a lookup table where the matching value only has two decimal places. Because of this difference, they don't match. I tried making a new table from the query and...

I need to convert grams in a query to pounds and ounces as two separte values. I am not a visual basic programmer, so does anyone know of a way to do this without programming? Thanks! -J

you need to make sure that the wizard button is selected as well, it looks like a magic wand, if it is not selected when you click on the button to make the combo box, or anything else, the wizard will not start.

that didn't seem to work, when i click on the down arrow, there is nothing in the list. Also, how exactly do i get to the solutions database? Thanks for your help.

I thought I better add, your new table might be: patientid diagnosiscode make both fields primary keys so that each record is unique and link to your main table by patientid. -Jeanelle

there are a few ways that you can solve this... The easy, sort of cheating way is: What are your favorite letters? choices are: a b c d On the form, have the person enter a d for example, then when you want to access that data later in a query and you want to see all the people who responded d...

I have a form where the primary key is called ptid. When I have someone entering data, I would like the form to display the record for that person if they already exist, but if they don't to just be blank. In other words, the data entry person is entering ptid 123, if 123 is not already in the...