Search results

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

Well, some progress....adding the following criteria to the Query under Client Contact does allow me to input a text search with good results HOWEVER if any of the other search fields are populated it returns zippo. Like [Forms]![TimeSheet Search]![Client Contact] & "*"

Thanks for the info zooropa66. The textbox values all appear to work as they should. The issue arises when trying to search using the [Forms]![TimeSheet Search]![Client Contact] Without this the other three function as they should with this one removed. Query runs, reports build all is good...

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

Bob, It likely may be my form but I'm not adding new records as much as I am adding new details and photos based on a specific date. I've switched to creating two tables: One houses the data that will never change The other houses the data that will always change I've tried joining the two...

Hi Bob, What do I need to input to the form to allow the database to hold multiple versions of the data based on the date input? To clarify: Have a form that needs to be completed monthly while maintaining all prior data. Thanks