Search results

I have a table that gets updated from a query. Some of our date is set to " No Change ". I'd like to be able to copy the last value that isn't equal to " No Change " to the next record until another unique value is found. For example. Date - Event - Next Event - Change 2/1 -...

I am trying to run an update from a form to auto-increment a number. Private Sub CatItemNum_Click() If Me.ItemCat = "3" Then Me.CatNumber = DMax("CatNumber", "CatItemNum") + 1 ElseIf Me.ItemCat = "4" Then Me.CatNumber = DMax("CatNumber", "CatItemNum") + 1 Else Me.CatNumber = Null End If The...

I am working on an auction database and have a basic framework(see attached). However I can't seem to get the categories to work right. It was requested that each auction item be able to be assigned to a category and then the item be assigned a number based on that. Ie mens would be in the...

I have a table that has two or three fields that are somewhat dependent on each other. ItemID which is a number(1,2,3...) ItemCat which is text(lookup from another table(Mens(100), Womens(200), etc..) Categorynumber(100,200,300.....) Is there a way to have it so for each ItemCat the ItemID...

I have a database that I'm working on(see attached). I'd like the report to "fill" horizontal lines to the end of the page depending on how much info was entered at the top for desciption and donation. Any help would be appreciated.

Is there a way to copy data from field1 on the previous record to field2 in a new record any time a new record is added. The only condition would be if field1 of the previous record were = to "XVYABC" then field2 would be populated with the last record that had data that wasn't "XVYABC"...

Is there a way to have a table or query essentially copy data from one field into a different field on the next record each time a new record is added. Table1 Record1 | field1 | field 2 Record2 | field1 | "Copy of Record1 Field1" Record3 | field1 | "Copy of Record2 Field1" Also if possible...

Is there a way to take two fields and compare them and list the differences. Ie. Compare field one "This is a good day" to field two "Tomorrow is better" and have a report stating what letters are in both fields, what letters are only in field 1 and which are only in field 2. Field could also...

Is there a way to take two fields and compare them and list the differences. Ie. Compare field one "This is a good day" to field two "Tomorrow is better" and have a report stating what letters are in both fields, what letters are only in field 1 and which are only in field 2. Field could also...