Search results

Thanks Guus for your reply. I dont need it for anything, I just was running an Ad-hoc query where it returns data with a date greater than whatever was needed. Because the people who want the data are slow at getting back to me they may change the date from. I built the query for it to prompt...

Hi Not sure if this can be done or not but I have a query where when it is run you are prompted to enter a date from. can the date entered then go into the field name. for example the query is for sales from a certain date (user selected). Whne run you are requested to enter the from date...

Thanks jzwp22 for your help with this I got your suggestion to work. Appreciate your swift response soryy I didnt get back with thanks quicker I have been in and out of the office.

Sorry I Screwed that up. Try to copy it from a spreadsheet and hit submit instead of Preview Thanks JZWp22 for the reply. I keep getting the lowest date. Here is how the 2 tables basically are and what I'm trying to get. This has to do with sales and the BDM who has a relationship with a...

Thanks JZWp22 for the reply. I keep getting the lowest date. Here is how the 2 tables basically are and what I'm trying to get. This has to do with sales and the BDM who has a relationship with a client. As BDM's come and go they want to keep the original BDM the sold the deal...

I am hoping somebody can help me out as this is the first time I have had to ask a question, normally I can search and find an answer. My problem is I need to find the maximum date before another date. I have 2 tables 1 with a bunch of records with a create date and another with a start date...