Search results

So yes I am still new to Access and have run into a snag. In my report detail section I have the following =IIf([Billing]="Daily",[Number of On Duty Days]*10,0) This does exactly what I need but now I need to SUM this, any help is appreciated.

I have been at this all week now and I need some help if possible: (using Access 2010 and not a web database) I have a form that I dropped a combo box on, I need it to display two columns as choices in the drop down, the Week End date which is defined within my table and the Client Contact which...

So I have been through all the postings I can read here but unable to address my issue: I have 4 unbound text boxes on a form to produce a filtered search on these four fields. The problem has been narrowed down to one of these fields "Client Contact" which is a simple text field identical to...

I have a database (currently one table) that uses one form and one report every month. In addition to this it will be used every month for the next 5 years. What I'm trying to figure out if I need to replicate the table, naming it monthly along with replicating the associated form and report...

I've looked over most everything I can find here regarding Access 2007 and linking or using attachments for photos. I can't seem to get linking to work as only the file name displays where the photo should be. I resorted to using attachments as it too is also a link versus being embedded but...