Search results

I have a minor dilemma I need help with. I have a report (based on a query)which informs staff of students who withdrew from our school, and the month and date they withdrew (sorted ascending). I am grouping by month and it looks like the attachment I've included. It works well enough, but...

In an expression, I am getting a syntax error message when I try to run the query with nested IFF statements involving numbers in different ranges. Would anyone please help me with the correct syntax. Thanks very much. =IIF([TableA]>-1,"On or Ahead of Target", IIF([TableA] is between...

I know this is an Access 101 question, but what is the best way to view text rather than numbers in my tables. In an example which I have attached, an Orders table shows the Customer field as a number. I would like to view the actual customer name when I am looking at the table. Thank you very much.

Hi, My name is Andy and I live in the Cincinnati area. I work for an online school and use Access daily. I am not a programmer. I guess I know enough about Access to be dangerous, but I'd like to get better. Best Wishes! Andy