Search results

between 2 dates and times Th data is in the query in this format 03/23/2003 6:00:00. I have a parameter query in this field . I'm not getting the results.

Between start time and date sorry for the confusion, the report is based on a query but I can not get it to work in the query... I need for the user to enter a start date and time of 6:00 a.m then enter an end date and time of 5:00 a.m.

We have shifts that run from 6:00 one morning until 5:00 the next morning. I will need a report printed on demand where that user can enter the First Date and Last Date - this is no problem with a parameter but how do I only get the report to include the right start time and finish time?? The...

This may be pretty basic...I want some forms to open maximized in my database while others I want tp open to the size that I saved them. Right now, my main screen opens maximized but then the rest of them open maximized too. Is there a way to have each open to a different size??

Hi, sometimes a value will nedded to be divided into zero. When this happens, I need the answer to calculate to zero to be used in another calculation. Here is the code in the query that I am using to try to convert to 0 but it is not working...What have I done wrong?? LgQty...

I'm using Access 2000 on Windows XP. When I do a subtraction in a query such as 30,000-30,000 which should result to 0, I get the result 3.6379.......on and on. Does anyone have an idea what the problem could be???

# Error Sorry! I still want a 0 to show because I need this value in another calculation to get a total sum...

Sometime there will be value in a field that a formula is based on, when there is, the formula works great...When the value in the field is 0, then there will be a division by 0 , then # Error shows up in my qery. I have a report based on this query, I don't want # Error to show up on my...

Sometimes the value will be zero, so how can I fix this equation?? Thanks...

# Error This is the calculation in my Query. I usually use the nz function without the 0....Could this be my problem?? LgQty: (Nz([LgAllocation])*Nz([WtPerTub])/Nz([No_Lg_Containers])*Nz([LgfrWharf]))

I have a pretty complicated calculation in my query. Sometimes I get a value returned sometimes I get #Error. How can I get rid of this??

I am new to being a DBA. There are users keying into a database I created until 3 a.m. How I can review data that they have entered after I leave at 5 pm until 3 a.m. to pick up on possible errors? Or should I need to do this?

I hava form / subform combination that is opened from another form. The main form is opened with specific data that the user chooses and then they need to add the subform data. The people who will use the program probably have never even used a computer before. The problem is if they keep...

I have a form based on a query. Sometimes there may be no data in the query so the form opens up blank. How can I get a message box to come up saying "There is no data to update" instead of opening up a blank form and under what form event should I put this code??

Hi, I have a form subform combination. The main form opens up to a specific record but when I try to add to the subform I get the message "The linkMaster Fields property setting has produced this error: The object doesn't contain the Automation object (my table name from the main form). The...

thanks, I already tried this as well. The calculation is done on the form based on a sum of records in the subform...

I tried both of these, but I'm still getting all records. The calculation is on the form.

Thanks, but I tried this already, then I realized this will only make the field invisible. I want the whole record not to show up..Any other suggestions??

Hi, I have a calculated value based on a subform and form displayed on my main form. When this value calculates to 0, I don't want this record to show. Only the records with a remaining inventory (that is a value greater than 0)should show. How can I only show the records on my form with a value...

Hi, I have a calculated value based on a subform and form displayed on my main form. When this value calculates to 0, I don't want this record to show. Only the records with a remaining inventory (that is a value greater than 0)should show. How can I only show the records on my form with a...