Search results

Ok so if I simplify this down to seach for a name (initials) and then a date range. how would I go about it? I placed an example in the attachment

I will give this a try and thanks for telling me something to try. There is no way at this point for me to change the table as was mentioned before your post. I am coming in on the back end a project that is 20 years old.

I have a table that has four columns of dates. 1. Assigned Date 2. Reviewer Date 3. Approver Date 4. Scheduled Date I would like to create a option for the user to select one of these four fields then search it by using a date range. Or can I have them select 2 or 3,4 of the above...

I found an even easier way to do this. I created a form with the two fields (columns) in question. Then On the orginal form I called this form up. I used the wizard to create the call for the form and in the wizard it asked me which fields are equal. I gave it the info and whoala it brings...

Does not seem to work :( Does it make a diffrence that Col A is a text field? Most are numbers as I stated like 10001 but some are WT20123 I now see that DMAX is used to find the highest number. Maybe I have made this to hard. Can I find the number... 1 2 Set 1 3 4 1 2...

I was task with moving a DB from Paradox over to Access of which I have no experence in either. I have figured out most of what I need to make this happen. One form that was present in Paradox is beyond me though. I will upload a picture of the screen shot might help in understanding what I...

I have a form that shows numbers from a table lets call it Col A. The number in col A is repeated over and over again say a product ID number. In Col B I have a second number like so Col A Col B 10001 1 10001 2 10001 3 10001 4 and so on 10002 1 10002 2 and so on I need to reference col A but...

Thank you for this post, after searching the internet for quite some time this solved my problem!!:)