Search results

Once again you saved me rainman! As always, thank you!!

Hi, I'm sure this is a very obvious question for someone, but not so much for myself. I just need a date range formula for a query. I want the query to ask me the start date and also ask the end date and pull up all dates falling in between. Anyone know a formula?

Rainman, thank you so much for all your help with this!!!!! You're a genius!

Do you know how I would then have the field in the form reference the specific tablename ID if I made a table with different fields being the table names? I guess I was trying to avoid making a combo box in the form - I just wanted it to know to insert it automatically.

The reason I wanted to have the name of the table stored in the table is because when I run the report I have all the information from 6 tables coming together in a Union Query, so it is not specifying which table the data belongs too. So, I just wanted to be able to add that field.

Here is the sample database. I was trying avoid having to create a set of information in a table to have it lookup the information and insert it. I thought there would have just been a formula to have it reference the form name or something.

Sorry I'm still confused....I inserted this dlookup("what you want returned", "fromwhere", "this= that") dlookup("Classroom Outreach", "Table Name", "Classroom Outreach= Classroom Outreach") and it's still not working. I have the field Table Name in my Classroom Outreach table that needs...

Thank you for telling me about Dlookup... I have tried 2 of the string formulas, are thoes the ones I should be using? here is the formula I inserted and it's not working: DLookup("FieldName", "TableName", "Criteria = '" & forms!FormName!ControlName & "'") DLookup("Table Name", "Classroom...

Hi, I am currently attempting to insert a formula either in the form or the corresponding table (whichever it is suppose to be) to automatically populate the title of the form/table (they are the same name) in that text box field to then have it be stored in the table with all of the other...

I'll trust anyone at this stage of the game....I'm desperate. : )

Yes, the fields do contain data. I almost think there is something wrong with my relationships. Do you think this is possible, and if it is any idea how to correct this problem? I am using a basic query...just opened the wizard and started selecting all of the fields I would like to be in the...

I am attempting to run a query with fields from 6 tables. These tables have been related, but just a simple ID to ID throughout all of the tables. When I select the fields I would like to be in query using the disign wizard it will allow me to create the query, however it will not display and...

I understand what you are saying about putting "November" on different rows in the criteria grid. That's awesome I didn't know that was possible. It is now working the only thing is, because the different fields are showing up on same row in the query table and because of this there are months...

I have been messing with a database attempting to run a query with multiple tables. Each of the table information I am inserting into the table have a field for the "Start Month". I have renamed all the fields so that they are unique, however they all still contain a month name (i.e. January...