Search results

  1. P

    Date issues

    Using a linked table which is an Excel download from a bookings app we use. As the “Time and Date” column was causing issues I created another field using the “Left” command and formatted it “Date”. Whilst my query accepts the date format, when I use” DatePart("w",[date])” and WeekdayName the...
  2. P

    Using Form Record No to Search Report

    I'm comparatively new to Access having spent many years using Lotus Approach. I'm self taught and find some of the the terminology baffling... trying to automate some processes in a database that I've created: I want to create a Macro that copies the record No from a Form, Opens a Report...
Top Bottom