Search results

NEw to access. I have a parent child relationship. I thought that referential integrity automatically added new records to the child table. Am I wrong? Is there a workaround solution to add new records?

They will go into differnet databases. It's not really necesary, but the boss says I have to do it

I have a table I am splitting into three tables in a one to one fashion(because I was told to do it) The Index of the original table is set to: Item Key (autonumber) and UPC Number I have created the two new tables from the original table, have added Item Key as the Primary key on the original...

okay, last question. I promise. You all have been so helpful, though... I have been given the assignment of splitting down a table into two more tables(three in total). My question is this: Could I use the Table analyzer? If so, what are the shortcomings? I would like to have the other tables...

thanks, I'll have to modify it slightly because I have two potential zero values in the denominator but I will keep this in my bag of tricks. To be honest. I knew very little about access and have been having to play catch up. I appreciate your help on these problems

wait, and replaces them with more zeroes. What the heck was I thinking that would solve my divide by zero error I was getting? argh. I appreciate the help.

AHA! the NZ only changes null values, not zeroes. That's what I was missing. thanks

I'm making a query with a calculated field from three other fields, Order Qty, Case Pack, and Case Cube. Here is the formula for the calculated field: NZ((([Purchase Order Detail]![Order Qty]/[Item Master]![Case Pack])*[Item Master]![Case Cube])/35.3147,0) And here are the datatypes for the...

I'm trying to run a VBA code that calculates the value of the duty rate per unit when I input the Duty Rate. I have another form where I use this, and it works: Me.Duty_Per_Unit = [FOB Cost] * ([Duty Rate] / 100) Me.Duty_Per_Unit_LCL = [FOB Cost LCL] * ([Duty Rate] / 100) But when I plug this...