Search results

I went through the code with a lens and cannot figure it out. Hired a programmer to help me out.. thanks all..

Thanks for the attachment I will take a close look. As for your question, I am trying to calculate the number of working hours between 2 general formatted dates fields. The results should not account for weekends, non working hours, and specific holidays.

I am trying to get the working hours with holidays and weekend removed between 2 dates. The code I am trying comes from this forum and users had success with it however I do not as holidays and weekends are not removed. I have atached a test database. Can someone pointme in the right...

Thanks Pat for the precision.. I know how to conctenate the 2 criterias (i.e. > 100,000) from the 2 fields.. What I do not know how is for the SQL to accept the > (from > 100,000) as an operator at the end of my sql query.

Please refer to the menu.gif for an idea of what I am trying to do. A Form referring to a large query where the user can select the results by selecting for each item either ">" or "<" and either an $ or % referring to the data. Each line should be OR, (but will settle for AND!!) I have been...

Wayne, Thanks for the reply .. This is more complete as a question I have a form which has a combo box ([Combo EB Volume]) with > and < as choice and a text field ([Text EB Volume $]) to enter an amount ($). These are used as criterias in a query with the following syntax...

My problem is that the > and < are not recognized by the query ("too complex" error) but it works when I enter the > manually and the $$ through the form.. [Forms]![AC_Dealer_List]![Combo EB Volume] & [Forms]![AC_Dealer_List]![Text EB Volume $] It's probably the format of the combo box that...

:mad: Access 2000: I create a pivot table from a table (no parameters) and get the error 'Problems obtaining data' in Excel...It reads up to a certain numebr of ercords (11,000-12,000 or so) then stops... I m used to do tables iup to 50,000 lines with no problems... Look at MIcrosoft Knowledge...