Search results

I would like to thank you again for your help. Another problem can up and I hope you can help again, I made the form but it will not let me update or add to it. I know that I did not do something. To make this simple I zip and attach the Database.

Thank You arnelgp that is what I needed

I cleaned up the queries, I do not know what you mean about the relationships. Here is what I am trying to do, Have a Table “Brown Wire CT” we list all of the teat wire in the Brown Wire CT Query it auto calculate the correction factor and I wont to do the same thing with Table “K Type Fluke”...

Thank you jdraw for that I just Zip it and posted it

That gut me the #Error

The "TEquip", "StartDate" are in a Table that go in to a Query where it add 30days to the startDate to make the "DueDate" I am showing you all the code I am putting in, if there is something missing I do know what it is. I am just copying and past, what is there I am new at this.

same, run without Error but the cell are empty

same s the last one, run without Error but the cell are empty

The last one run without Error but the cell are empty

If I change it a little the first cell is right but the rest have #Error Expr1: Val(DLookUp("[cf-10]","[K Type Fluke Query]",("InstrumentID=" & [TEquip]) And ([FreezerSAT1].[TDate] Between [StartDate] And [DueDate]-1)))

I copy what you sent and I am now getting: “The expression you entered as a query parameter produced this error: ’Microsoft Access cannot find the name ”TEquip” you entered in the Expression’

I tried the Dlookup but gut #Error. Expr1: DLookUp("cf-10","K Type Fluke Query",("InstrumentID=" & [TEquip]) And ([FreezerSAT1].[TDate] Between [StartDate] And [DueDate]-1))

It looks like I can attach the Data Base. when I run the IIF I get #Error I have Attach two snipping. Data Fluke and What i need. when we put in a test date in (What I need) I need it to go to Data Fluke find the startdate and enddate the tdate fall brtween and the TEquip maches and put the...

I am very new to access, I think I just attach the Data base I am working on.

Hi I am new to Access and hopping someone can help me. I have a query called FreezerSAT1 that we put the date (TDate) we do a test and what equipment ID (TEquip) we used, in another query I have all the equipment ID (InstrumentID) the date (Startdate) the equipment was calibrated and the...

Hi All, I new to Access.