Search results

  1. A

    Populating data from a table with multiple fields

    So many questions relating to this here and elsewhere, but I just can't equate any of the solutions to my challenge. I am trying to create the form so when the first field (Start Date) has a date selected, it limits the following field (Report Date) to the matching available data, and same...
  2. A

    Relationships and referential integrity in linked/imported data DB's

    Have a huge DB that I did too much work to before making sure I was creating it properly. Was back tracking and trying to normalize and set up relationships and referential integrity but ran into the following issue: The database uses tables which are periodically updated through imports from...
  3. A

    Toggle on form to query between two criteria

    I am attempting to create a toggle on a form that would instruct a query which criteria to use. Specifically they are date criteria. I want to be able to toggle between evaluating on a start basis verse a ship basis. If the toggle is set to 'Start Date', the query would use the start date as...
  4. A

    Lookup/Match function help please

    I am trying to perform, in Access, the equivalent of a HLookup combined with a Match function in Excel. Converting and automating a process I originated in Excel into Access, but its been several years since I used Access regularly. Here's the data and what I am trying to do.... Table...
  5. A

    Back to Access

    Hi all, I used to do Access programming back in the mid 90's and after enjoying the outside world for many years I am now back in an office hacking away. Working on several large projects to improve data flow at a large Greenhouse operation and am running into several walls - look forward to...
Back
Top Bottom