Search results

Yes! I just caught that myself... sigh, TGIF!

Sorry - didn't see that this question took on a life of it's own. I did get my problem sorted and working, btw. I have over 250 job/processes managed by a dozen working groups and some had 12 processes and some had as much as 30. So I added another field to my job/process table and numbered...

I have been reading until my eyes are blurry and I can't see what I have missed on this... I am using Access 2010 and trying to get the following statement to work in VBA: strSQL = "SELECT * FROM qryByTimeEmail" & _ ' " WHERE qryByTimeEmail.ShiftDate = Between #" &...

Before we try and get your crosstab working, I have to tell you that the end goal is a very bad idea and will cause even more headaches. If you have a better suggestion, then I am all ears (eyes)! I have the users inputting their audit observations on a form and wanted to have a subform with...

I have been trying to figure this one out all afternoon and I'm getting nowhere fast. I am running Access 2010 and I am trying to create a crosstab query that will populate a form. I have a table of employee names with their corresponding group name. I also have a table that lists all the job...

Hello, this may seem like a stretch, but I have been reading some of your posts from 2003. I am interested in doing some automation between Access and Project. In a thread (http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=47358&highlight=project+and+wayne), you noted...

I have continued to dig and think I have found what I need... but initially had a little trouble with the syntax. I found this link: http://www.geeksengine.com/article/get-single-record-from-duplicates.html and the query is what I want but it's for an Oracle database. I have managed to get it...

thank you for your assistance but this is still not what I am looking for.

Okay, I will try to make this clearer. The inventory table is used to track the sealer that comes in barrels and is used in the shop at the company I work for. We get several different types of Sealer and there are 12 pumps in the shop to which these sealer barrels are put on. The Sealer has a...

The results I am getting are: InventoryID PumpID SealerType ExpiryDate Lot 13 12 A 05-06-2016 123 12 11 A 05-12-2016 114 11 10 B 05-31-2016...

Hoping someone can help me out with this one. I am using Access 2010 and trying to create a query to show the last records for 12 unique foreign keys in a table. I am tracking sealer inventory for 12 pumps in a shop. Each pump can be changed multiple times in a week. I need a query that...

Plog, quite simply, I have time fields in my table, and in my query on my first post, I indicated "Hour([EnterTime]) as InHour which giives me the hour value = 11 or 10 or 9 as the vehicles are logged in. I'm not trying to make a cherry pie. In a nutshell, the database is tracking vehicles...

yeah, I didn't think so... I am trying to convince my user to use a report (essentially two subreports side by side) to get the desired results.

Apologies, should have been more specific. What I get is: Date | hour in | total hour in | hour out | total hour out | Type 3-15 | 9 | 1 | 10 | 1 | Commercial 3-15 | 10 | 7 | 10 | 7 |...

I am using Access 2010 and trying to create a query to count records by hour. The fields in the table include: EnterDate, EnterTime, ExitTime, Type I need to count the number of vehicles that enter and exit per hour on a given day and show by type. My SQL is as follows: SELECT...

I am trying to find a way to count unique values in non adjoining columns in Excel 2010. I have 8 columns (AF, AN, AV, BD, BL, BT, CB, CJ) containing employee IDs and I want to be able to count only the unique values across all 8 columns. Any thoughts / suggestions?

Thank you Gemma/Dave.... sometimes the simplest solution is the best!

Hi Gemma/Dave & arnelgp, Yes, it is a subform. Let me explain a bit further. The mainform is unbound and has a text box (CharityName) and a list box (CharityList) on it. I am using it as a search form with the following code: Private Sub CharityList_AfterUpdate() UpdateSearch...

Sorry doesn't fix it. The error no longer comes up, but the subform does not populate with the selected Charity data. My Charity field is an indexed text field.

Yes, I have several with a single quote.... many of the names are possessive or in French. Should I be removing the single quotes or is there a work around? I have over 86,000 records in the table....