Search results

Fe/be Would I then be able to change and replace the front end after I make my changes? How does this prevent having to make sure no one is in the file?

Fe/be How do I go about doing that?

My database is on a shared server and many people are able to access the database at any time. What would be the best method to create a way for me to make design changes, etc. without having to make sure everyone is out of the file to allow me to open exclusively?

My problem started when upon running a macro that runs a report, the message "Record is Deleted" was returned and thus the report did not run. This is very strange because it worked ten minutes prior. Upon further research, I found that the table that is queried for this report could not be...

David - thank you so much for your help. I was able to solve the division problem and that seemed to eliminate the blank dates for whatever reason. Thanks again.

The query did eliminate most of the null dates, but included a few (4 out of 273) blank dates. Any thoughts?

Very nice work, it works like a charm now. I did forget to ask you one thing. I need there to be another If statement to return not only records between those two dates, but also make the field Division from my table equal to[forms]![frmflash]![Division]. You are a lifesafer and I appreciate...

Thanks, that got me headed in the right direction and I have a solution.

I need a query to look between two dates. The first date needs to be the first of the month of date given in [forms]![frmflash]![enddate] and the last date needs to be [forms]![frmflash]![enddate]. How can I make a between statement that looks between these two dates? Thank you in advance.

I appreciate you helping me. Perhaps I am missing a step somewhere, but it is not allowing me to use the above statement in my query. I received an error message as follows: "The syntax of the subquery in this expression is incorrect. Check the subquery's syntax and enclose the subquery in...

The column in the query is as follows: SaleDate: IIf([salesdate1] Between [Forms]![frmFlash]![StartDate] And [Forms]![frmFlash]![EndDate],[salesdate1],IIf([salesdate2] Between [Forms]![frmFlash]![StartDate] And [Forms]![frmFlash]![EndDate],[salesdate2],IIf([salesdate3] Between...

Each record in my table has six possible sale dates as a result of cancellations. My problem results when a record is sold twice during the queried time frame (SaleDate1 and SaleDate2). Currently my query uses an if statement and if they are in the same time period, it will only return...