I am managing access to a building. Each access card has a number. Each student is given a card when they start working here and they return it when they leave. The access cards have to be activated for each person so I need to keep track of who h...
I tried that. I used this:
{Student Name}&" checked out card on "& DATETIME_FORMAT({Date Checked Out},'M/D/YYYY') & " and returned it on " & DATETIME_FORMAT({Date Returned},'M/D/YYYY')
But I get an error message.
Thanks for your help, I completely forgot about bridge tables. However, when I try to set up the formula for the primary key, it displays the full date and time even though the column I’m referencing doesn’t collect the time. How do I make the form...
I am not sure what you are asking. Could you describe it in terms of tables? Please list a simplified version of your tables and their columns and then describe how you want them linked.
Table 1
Name
Address
Phone
Table 2
Item
Color
Price
How are y...
