Search results

ok, so ive uploaded some sample data if you go to frm_Eng_MCU_InServiceIssues you'll see the form, which i have the sub forms, there is a corresponding query for each sub form, which are labelled the same all of the data for these forms come from frm_Eng_MCU_Tracker, and are filtered in the...

thank you i will put some sample data and upload it

the way the form is set up, there is no relation, the data is displayed on different criteria

ok, so the data thats being displayed in the sub forms, will change over time, but what i want to do is capture the data is it is when in the form. i am assuming as the data being displayed in the sub forms, are linked to data that will change, so will the data in the sub forms, i need to be...

hi all i just wanna make sure im doing something correct so i have a form, and in that form i have 9 sub forms that are set as continuous forms although the data comes from the same table, i have used 9 different queries, for the sub forms, to filter the data correctly is this the correct...

hi can i use a Dcount function inside a query? i have sample query here VehicleNumber | MCUDate | SubSystem 01|12/06/18|doors 01|13/06/18|doors so i am trying to create a query to look at the vehicle number and subsystem, and count then number of matching events over a 14 day period, i can...

thanks for the reply i tried to use that in the formula but it didnt work heres what i tried LastDone - Date()

Hi How can i use todays date in the expression builder when creating a calculated row in a table so i want to be able to deduct todays date from another row.

thanks for the pointer, works perfectly

thanks for the reply it fails with error code 438 object doesnt support this property or method

Hi I have a form that creates records, and saves them in to a query. i also have another form displaying the records in a continuous form. how do i get the continuous form to refresh the data, once the first form is saved or updates. here is my code i thought would work but doesnt first...

ill take a look thanks im still new to access, where does the query need to go?

Hi Minty Im still struggling with this, i've inputted the function in the control source, of the required field im trying to calculate, which is "Failure Level", but all it displays it #Name? just for clarification, i reference the field name not the column name in the query/table?

this is my function but it keeps saying the "expression you entered contains invalid syntax" =DCount("cboVehAtFault","Query_MCUTracker","[MCUDate] > Date()-14 AND [cboSubSystems] = '"Me.cboSubSystems & "'") i have put this in the control source of the field

can i not store the value in the query? just so i can use it on another form?

thanks for the help minty, ill take a look at the formula the field name isnt "Date" i was just using that as an example, but thanks for the advice

Apologies So i have a form bound to a query, relvant fields VehicleNumber | Date | SubSystem V003 | 10/05/2018 | ATO V003 | 01/05/2018 | ATO the field i would like to apply the formula to is called "Failure Level" This would be based on VehicleNumber and Subsystem, within a 14 day period...

hi all i know the COUNTIFS function doesnt exist in access, but what would be the alternative. i have a excel formula to lookup two criterias within 14 day period =COUNTIFS([V At Fault],C2,[Sub System],O2,[Date],"<="&A2,[Date],">="&A2-14) what would the access alternative be

got it to work

Apologies, that was a misspell i have changed it.