Search results

  1. R

    Databse Theory/Design

    Hi I have been asked to design and build a database to track maintenance and i have a few questions: Scenario: There are multiple things that need to be tracked/recorded. TBL_Maintenance -MaintenanceTaskNumber -WorkCity -WorkSite -DueDate -DescriptionOfTask -ActionRequired -AccessStatus...
  2. R

    complicated query

    Hi I have a table call ed Archive. i need a query that would produce the following results Must be within one query. I'm after a distinct list of names To look within the field Hashtag to find if there is text "#LEFT" If there is i need the first Calendar date it appears against their name...
  3. R

    syntax error in update statement

    I have 2 tables called MakeTable1 and DBO_TBL_Activity Im trying to update MakeTable1 with the values from TBL_Activity when both activity.StartDate and maketable1.Dates match but also acticity.IDStaff and Maketable1.ID Match Below is the SQL i have so far UPDATE [MakeTable1].[Detailsa]...
  4. R

    Excel formula converted to access formula

    Hi I built this and it works in excel but i have no idea on how to get it to work in an access query...
  5. R

    Passthrough query to remember password

    Hi I have the following query that has been developed for me but it constantly asks for the password. Is there a way of storing/automating this for reporting? SELECT dbo.tbl_staff.Name, dbo.tbl_function.funct, dbo.tbl_dates.CalendarDate, dbo.tbl_activity.Details FROM dbo.tbl_staff INNER...
  6. R

    create missing records

    Hi First post on this forums! be gentle! I have a table called Imported that contains rows of data with calendar entries. What i need is a query that would add in the missing dates With the details field been marked #Free o it would have concurrent dates I have uploaded a sample of the...
Back
Top Bottom