Recent content by thesven

I figured this out if anyone is interested =Sum(IIf([Billing]="Daily",[Number of On Duty Days]*10)) Apparently you can't sum a text box from one section to another.

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 can appreciate your request however the data is live on the table and confidential. One caveat here is that the form/report/query is running against a SharePoint 2007 list which is being treated like an Access table. The list resides on the server and I am just making calls to the list...

As a test I have switched to a List box and I am now able to see the Week End Date and the Client Contact as one selection in the List Box. My issue of not being able to display the individual record still exists though.

Thanks for the update! I tried columns 4, 5, 6 but still blank results. :confused: In the ClientSearchForm I have the Query Builder on the unbolund Combo84 set to: SELECT TimeSheets.[Week Ending], TimeSheets.[Client Contact] FROM TimeSheets WHERE (((TimeSheets.[Client Contact]) Is Not Null))...

If I don't use a command button and place the code in the After Update event I get the same exact results.....a blank record.

Okay here is what I have: On the form: Unbound Combox = Combo84 Row Source = SELECT TimeSheets.[Week Ending], TimeSheets.[Client Contact] FROM TimeSheets WHERE (((TimeSheets.[Client Contact]) Is Not Null)) ORDER BY TimeSheets.[Week Ending], TimeSheets.[Client Contact]; Command Button83 =...

Thanks for the point in the baldy direction. My struggle begins I suppose as I have zero knowledge of VBA. Maybe I can find some samples...

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...

The form runs a query. Not sure I understand your question.

no, these are the search boxes on the form, upon clicking the "run query" button the results are derived.

I tried the process with the same results. I rebuilt several new queries to try and figure this out, all yielding the same results. If I place Like "*" & [Forms]![SearchForm]![qclientcontact] & "*" in the Client Contact criteria section of the query I can search and retrieve this filed IF all...

I can appreciate and understand the request however this is a live database housing a multitude of confidential information as you might imagine. I am currently just trying to build a search form against the database. I am willing and able to try any possible solutions to my problem and...

Here is the SQL as referenced in my last post WHERE (((TimeSheets.[Week Ending]) Like Forms![TimeSheet Search]![Week Ending] & "*") And ((TimeSheets.[Employee Name]) Like Forms![TimeSheet Search]!Employee_Name & "*") And ((TimeSheets.Client) Like Forms![TimeSheet Search]!Client & "*")) Or...

If I move the Like [Forms]![TimeSheet Search]![Client Contact] & "*" to be an OR criteria the other fields work as they should but the Client Contact data set is always returned with those records that contain data in this field even thought the unbound text box is blank when the search is done...