Recent content by Cliff

Thanks. There was a "record deleted" field in each table - they had unique field names, all the fields do. I didn't allow records to be deleted, just changed a 0 to a 1. I set the query to say the patient table = 0 and the tx table = 0, and oddly I couldn't get all of the records. I made...

I have two tables, patients and transfusions. Not all patients are transfused. I want to create one query that will show all patients, regardless if they were transfused. Also, each patient may have more than 1 transfusion event. Pat A Tx 1/1/2016 Pat A Tx 1/2/2016 Pat B Pat C Tx 2/1/2016...

Thank you, this looks like it will work.

I am doing a Biggest Loser challenge at work and have a nice report that shows the users their weight loss over time. I'd also like to add a table that shows the group's starting weight and the group's current weight. I have one simple weights table that lists the ID of the contestant, the date...

Thanks, but that just seems to list more rows, not show all of the data in each row.

I have a form with a combo box that the user will use to select from a predefined list of data. When I click the drop down the data scrolls to the right and I can't see all of it. If I select one of the items on the list, I can see it in the combo box display. Is there a way to control the...

Thanks, but I'm not sure that is what I want. I want all UNIT_ID from the COMPONENTS table unless there is an ATTRIB_CODE of "X" in the ATTRIBUTES table.

I want to create what I thought was a simple select query. I have 2 tables. COMPONENTS UNIT_ID COLL_DATE ATTRIBUTES ATTRIB_CODE UNIT_ID The COMPONENTS table lists each item only once, the ATTRIBUTES will have anywhere from no ATTRIB_CODE values to several. Here's and example: COMPONENTS...

Thanks for all the help!

Yikes, I knew I had registered for this awesome forum before, but couldn't find that registration. If an admin could merge Cliff with ctreeves, it would be appreciated.

Excellent, thank you. It is a text field, some of the values start with a 0. So will I need to create those 40 fields in the table first then update them or is there a way to create the fields with the update query?

Ugh, I just noticed I typed the name of the post wrong, if a moderator could change it to "Split one field into many" I'd appreciate it.

Thanks for the welcome, and for replying. The table I referenced is a system function table - this was extracted from a bigger database that runs an application for us. This table lists a function, let's say "Create Reports", then there are 40 different groups each with an access level of 0 to...

Thanks, this is killing me. There were just over 250,000 records. I deleted all but 20 of them. Removed all of the columns I wasn't looking at. Compacted and repaired and I still get this error. I tried creating a whole new table with a new name and entered only a few records, and I still get...

Thank you again for the quick reply. I am getting a different error now, but suspect it may be related to my data. "Reserved error (-1524); there is no message for this error." Some of the fields also have a number in them, for example, I have Fy3, Fy4, A1, A2. Are the number causing the error...