Recent content by Satin

thank you so much.

I will absolutely try this. unfortunately, the dates can be all messed up like they are in the example.

I will look into this too. I would continue it in Excel but I am trying to teach someone else how to do it and they don't understand excel and formulas. So it makes it more challenging for us both. But if I could set access up where all they have to do is import and run queries I feel it would...

I was trying to get it all in 1 query but I just couldn't figure out how. I need all customers who stayed 30+ consecutive days no matter if they have 1 or 20 reservations. However, some customers can have 5 stays but have gaps so they are not considered staying 30+ days. I hope this makes sense.

Thank you. I will read up on Cartesian Query and see if this may be what I can use.

Good Afternoon, I currently have a table with Customers with the following columns: CustomerName StartDate EndDate ResNumber - this is unique to each stay This table will have hundreds of rows, as each customer has the ability to have multiples start and end dates and the days between can...

Thank you so much. Yes a lot of what I do is compare reports. Sometimes the reports can be in the upward of 100K of data and that is when Excel begins to tell me no ma'am. I will continue to dabble in Access it seems to work great for my project management and look into Beyond Compare for my...

It is strange to say the least. but man these drivers on the freeway are going nuts. 100 plus or at least 90 when i am going 80 and they zoom past me. but i had to drive down the strip and it was so spooky to be so dead.

That might work. let me play with it some more and see if that brings about the results I am after. Thank you.

That makes sense. Kind of like what I do with Excel. I have a count formula then a match formula to see if they match exactly.

That makes sense. I am trying to get out of a data sheet set of mind into a database. Apparently not an easy step for me.

I added a table. Sorry it took me a second to find it.

Good Morning, I am very new to Access. I currently do most of my work in Excel and am trying to switch over to Access as some of my data is too big for Excel. One of the things I do weekly is a review of people (compare two reports to see if they match). I do this in excel with lots of...

Good Morning smart folks that know more about Access than myself. I am very new to access. Just created my first database this past week. I feel it is a rather simple database with 2 forms for data entry and multiple tables for that data where I can run simple queries n the future. Typically...