Search results for query: *

Can I use an "If" statement in the critera of my query? If so, I am trying to return a value from a table in one column based on the condition of another column? Is this fesible? How do I do it? Thanks Jim

Part of my Db is a time clock type system in which my employees "clock in" and "clock out" of lunch and the workday. Is there a way that I can work with these timestamps (formatted as HH:MM) where I can calculate sums with the existing data? Being that it is base on 60 minutes to the hour I am...

I am trying to build a report that gives me the sum of the values in a field of one of my tables. I would need this sum to only be from selected entries in that field (conditionally selected by the entry in another field in the same table), also I need to format the entries to be summed up...

I have inserted a date/time box on my form and I would like to refresh it. It current just remains at the D/T when I open the form. So, how can I refresh data in certain portions of my form? Thank You Jimenda

I am setting up a time card type Table/Form I would like to have the time values entered into my table from the form to be negetive values if the user choses "back from lunch" or "clock out" in another combo box. Right now I have hidden text boxes that timestamp my record (I have done this to...

I would like a certain combo box on my form to only be visable (and functional) if a certain value is chosen in another combo box on the same form, is this possible? I also am looking to have a audio response made (in WIN XP) if a Certain value is chosen, how do I make this happen? Thank You...

I would like to have a text box on my form that displays a running current time. I would need to use this text box to timestamp any entries thru the from. Any help would be appreciated. Thanks Jimenda

I need help to see what I am not seeing, I have five combo boxes on a form, four of them you can drop down and select an item from the list, the item is then displayed (selected) in the combo box area. My fifth box will drop down yet it will not select, what am I not seeing here? Help if you...

Hi, When my ACCESS Db is first opened I have it display just my form without a window. My form has 8 combo boxes in which items are selected and then save to a table by clicking a submit button. My problem is that whenever I open my database my form displays as it should, but it...

I have a table with about 10 different fields, I would like to retrieve data from this table. What I am looking for is how to set up some type of shell in which I can choose a value and a field and then have each record in the table in which the field value matches my input value, then import...

I have a form that has 7 combo boxes, I would like to be able to make a selection in each box (if no selection made, then default or null), and then click on a button and have the selected items in each combo box to update/add 7 separate fields on a new line of a separate table. If anyone can...