Search results

Here is the SQL: SELECT [Issue Tracker].ID, [Engagement Links].[Account Name], [Issue Tracker].Client, [Issue Tracker].Issue, [Issue Tracker].Category, [Issue Tracker].Description, [Issue Tracker].Priority, [Issue Tracker].[Assigned To], [Issue Tracker].[Target Completion Date], [Issue...

When I open the query it immediately asks questions for creating the table. It does not give an option of SQL in the view list. Is there another way to look at the SQL? qry_data_new is a Make Table query.

Hi, I just wanted to make sure someone saw my question from yesterday. I hoping you have an answer for me. Thanks!

I am creating a table using a make table query. The data from the table is used in a mail merge Word document. I noticed that the data entered in text boxes is not displaying in the word document after the mail merge is completed. Then I discovered that the text data is created as binary in the...

:eek: Oh -- did not know that would be a problem. How do you suggest I do this? This table is used in a mail merge word document. The mail merge or word documentation I found says that it is better to do the calculation in Excel or Access. Since the origination of this data is Access, that is...

Thanks for the suggestions. I actually had figured out the syntax but was more concerned about getting it into the table. The solution I came up with that works, outside of VBA, is to calculate the date directly in the field in the query that creates the table data (make table query). REPORT...

I need to add 7 days to an existing field and store in a different field in a table for use in a mail merge document. What is the syntax for doing the calculation and storing it in the first occurance in the table? Thanks very much, jketcher

I would say I am a 4, but am a touch critic since I used to be a COBOL programmer. I did get this to work though. Found some other feedback before I got your response. VBA is making more sense but some of the syntax seems like gibberish.

Sorry -- I need an example with explanation. Thanks, jketcher

I recently got some help with filtering data in a table using multiple combo boxes. Now I need to export that filtered data to a text file. The data is displayed in a subform [Marketing subform]. How do I do this? Do I need to create a recordset from the data that is displaying in the subform...

IT WORKED!!!!! Thank you so much!!! :D

Is that exactly how I should code it? It seems that if for example the first combo box starts building the filter, the second one would find the length of the filter to be >0 and apply the true condition: 'Filter for length of Program If Len(sFilter) > 0 Then sFilter = sFilter & "AND"...

OK -- did more research and created a string to build the syntax to include all of the combo box criteria. But it still does not work. It is only building the string for the last combo box in the code. I commented out the last box and it selected data correctly for the last active combo box in...

Where clause -- you mentioned it in an earlier thread and it just now sunk in. Do you have an example? I do not know the syntax for this for VBA. Thank you, jketcher

Still stuck on something. I put VBA code under button control and it is still only filtering the enrollment control - ignoring the others in the final results. Here is my code. What am I doing wrong? I tried a couple of different scenarios for turning the filter on with the same results. 'Use...

P_2D7A has been working in this DB without the Me!. When is it necessary to use the Me! or Me. and when do you not have to use it? There is soooo much to learn.

Yes -- Me! refers to the form object (combo box in this case). But this calculation requires getting the data from the source table which has led me to adding a calculated field to the query which should solve the problem in a different way. Thanks!

Your code: Und_Grad = Nz(Me!C_P2D7A,0) + Nz(Me!C_P2D7B,0) The fields are actually numeric data from the input table not combo box data. The combo boxes are check for ranges to filter selections. So would the code then be? Und_Grad = Nz(C_P2D7A,0) + Nz(C_P2D7B,0)

New syntax question. How do I add two fields together to use the result in a filter? My code that is not working is below. I am totalling undergraduate and graduate enrollment. Do I need brackets around the fields? What else? Do you have good examples for syntax in filters? I am getting stuck...

I am back! Have a new issue that I need advice on. There are multiple combo boxes on the form. The ones that I don't need to choose 'All' for have the selection criteria in the query. The others are VBA code. I noticed that when I make the selection from the last combo box it ignores the...