Search results

Solution: Well, it's probably not the cleanest thing in the world, but I just created another table with each charge month. Then, I wrote a query to show an obligation record for each month if the charge date falls within the start and end date. Meh, it works.

I have a simple table with the following fields: -CaseNumber (text) -Obligation (currency) -StartDate (date) -EndDate (date) What I'd like to do is create a query that displays a record for the obligation on the 1st of each month between the Start and End date fields. Something like...

Well, kiss my grits, it worked. That greatly simplifies my life. I'd give you double thanks for the Yodaese if I could. At first I didn't know how you could've guessed I liked Star Wars... but then remembered my screen name. Does my ignorance know no bounds? Thanks again!

Hi there, I have an Access 2007 front-end with a SQL 2008 backend. I am successfully using a form with combo boxes to filter my passthrough query by using a command button to rewrite the SQL string based on the data on the form. My problem is that I am having difficulty writing clean script in...

I put a reminder for myself on my Outlook calendar. :)

HOO-Rah! Thank you so much! Adding your second line to my criteria worked perfectly.

Hi Spikepl, Thank you so much for your response. I've semi-successfully used the Nz function, but my problem is that when both fields are left blank, the records with null date fields don't show up. Here's the code I placed in the criteria line of my query: Between...

Apologies if this is a duplicate thread. I have a form where I would like users to filter a date range in a query. Ideally, the users would be able to put a date in either, neither, or both of the designated text boxes to apply the proper date filter to the query. I can reference form...