Search results

Not that does not help, if I put the format to dd/mmm/yyyy then enter 01/09/2014 it automatically changes the date to 09/01/2014 Which is extremely puzzling. Help:banghead:

I have a very strange problem, I have a field set to date Format: Short date, Input mask 00/00/0000;;_ on Every Windows 7 PC I enter a date i.e. Today 01/09/2014 & that date stays at that format but on the 1 pc i am having a problems with, Windows Vista PC when I enter 01/09/2014 it changes to...

I have finally worked out the formula. CostKG: DLookUp(selected_costset_no(),"tbl_CostSet","[ing_resource_code]='" & [ri_Resource_code] & "'") :banghead::D

I have a query that looks up a table to get a cost. Query:- QRY_recipe_ingredients Fields:- RI_Ing_ID, RI_Resource_Code Table:- TBL_Costset Fields:- Ing_Resource_Code, C100, C101, C102, C103, C104 In Query (Qry_recipe_ingredients) I have a field "Costset1" that looks up TBL_Costset & gets the...

I have 2 querys Qry_Data & Qry_Data_total Qry_data has a list of ingredients with there grams_per_pack Qry_data_total sums the grams_per_pack from Qry_data I then have a form that does some calculations & a dlookup to Qry_data_Total I have tried a sum expression but that stops you adding new...

New to Access 2003 & programming. I have created a database to calculate costing recipes the form has a couple of subforms as well. When I change the yield in the form the subform is recalculated, but when I change the yield the calculated field goes blank & calculation appears in the bottom...