Search results

  1. G

    Calculated Field Question

    Good morning all Apologies this may sound an easy question, but I am going round in circles due to "The expression cannot be used in a calculated cell" I have a calculated cell that works as follows, apologies column names arent my choice as it needs to be built so the data output table can be...
  2. G

    Calculate time

    Good afternoon, I have created a query that calculates time, but it doesnt appear correct I think. In my source table ([time]) I am calculating the time spent that has been registered for jobs completed in a day, which seems to work but my times calculated together show as...
  3. G

    Union all & NZ query

    Good afternoon, I am new to SQL and I have jumped I think in at the depend end. I have a table called "All_data" that I want to populate from weekly tables (44 & 45) All data has 27 columns but my data in Week_45 start with partial data and can complete up to all columns by the end of the week...
  4. G

    Auto populate a userform via a reference

    Good Afternoon, I am new to access and am a bit stuck. I have a userform i want to populate once a reference number has been entered into a unbound textbox. Can anyone point me in the right direction to create a macro that will pull the data out of my database? sorry if i am being vague...
Back
Top Bottom