Search results

That worked exactly like I needed it to. Why is it not a good idea to use it that way? Thanks so much Rick

I am trying to use DCount in a query as an expression to return a value of a count in a table. My table name is SerialTest and the field name is ModelID. My table has three fields, SerialID, Serial Number and ModelID. The SerialID is the primary key , the Serial Number is a field that the...

This is what the problem was. I thought that it needed the underscore because it had a space between Serial and Number. I removed the underscore and it worked. Thanks for the help

I made the change but now I get this error: Run-time error '2471': The expression you entered as a query parameter produced this error: '[Serial_Number]' Any ideas what is causing this? Thanks for all of your help Rick

I need to make a correction , in case it matters. I said that I want to compare it to a table on that form . Actually when the form is opened I run a query and I display the results on the form. The query name is OpenAlert and the field name is Serial Number. Any result in the query...

I have a form with several tables. One table (SerialTest) has a field (SerialNumber) that the operators select a serial number from a list. I need to check another field (Serial_Number) on a different table (OpenAlert) to make sure that the serial number is not in that field. If it is in the...

Bingo, we have a winner! This was exactly what I was trying to do. It works perfect. Thanks Rick

JHB, I did get it working in my DB. But I have a question. When you run your example , you will notice that it prompts you for each date line, so the second and third date line prompts for an entry. In my db , I use machine serial number instead of a date line. So it prompts me 23 times before...

JHB, I tried the example that you sent and the concept is there and it does give me something I can work with. My goal now , is to edit it to work with my query names and field names. Also as you mentioned , it writes the output to a table, I need it to be in the query output, but I think I...

Jdraw, My query already shows the amount of contracted hours covered per month, which changes from month to month depending on how many weekdays and weekend days there are for that month. This part of the query works perfect. The same query looks through my workorders table for the same time...

So either , no one understands my question or they dont know if it can be done?

I have a table that has the amount of hours covered Sunday thru Saturday. The table has 16 hours per weekday for each day and then 8 hours per day each for Saturday and Sunday. Then I have code in a module that determines how many of each of these days were in a particular month since each month...

I have a field in a query that shows amount of hours a site is covered. This field name is Coverage hours and it changes depending on the number of work days in a month. This part is working correctly but some times addtional hours may be requested by the customer. I want to add a another field...

MS Office 2003 I have 7 queries that I use to export data to one excel workbook. Inside the workbook are 7 worksheets, one for each query. I have it working but I dont know how to save the exports steps like I did in AC2010. I export the data by right clicking on each query and select export...

I have a query that has a field that reads DateReceived By Month: Format$([Workorders].[DateReceived],'mmmm yyyy') The criteria line is Like "*" & [Enter Month & Year (Leave Blank for all)] & "*" And this works when I run the query. If I enter october 2013 it shows only records for this date...