Search results

I have four fields that are checkboxes. I want to create a variable called ‘percentage complete’, and populate it based on the checkboxes. For every checkbox that is checked (yes, -1) I want ‘percentage complete’ to go up by 25%. I’d like for this to happen in a query, so that I can pull the...

Creating Pie Chart from Count Query My Data gets one of 4 labels: A, R, N, X. I want a pie chart that shows how many of each I have. I created a query (StatusCounts) using Group By and Count. It lists “OrderStatus” and CountofOrderStatus. Whenever I use this query to create a chart I get...

My database has a text field "Status" where the text is either, A, W, C. There is a form to update this field; currently it uses a standard Access created text field. The users want a checkbox which will show up as checked when the status is W, if the status is anything else, the checkbox will...

I recently inherited a database that seemed to be designed by an expert VB coder. After carefully picking through the code for about 2 days I realized the person had just used the Switchboard function. I made a few small changes in the switchboard (through the switchboard wizard), and everything...

I have a database with a date field of 'ReviewDate'. In the same table there's a text field of 'Expired'. I want to set the default value of 'Expired' to be "Y" when the reviewdate has passed, or "N" when it hasn't passed. Users may also enter other options ("A" for waiting or "H" for on hold)...