Recent content by inspectorgadjet

Yes I meant fields. The lookup reads the items listed in the other table and allows you to tick multiple checkboxes. Once you click OK it places all the item names in a comma separated list in that field. When you have the drop down with items visible it also lets you display other columns from...

I've created a table with a few columns and used a lookup on one of them. The lookup looks up items in another table which have a name and a price. The user can select multiple items, and it then saves the list of items to the column. I need to also take the prices for the selected item and...

Hi, I am currently a SQL DBA, and have been roped in to help a fellow staff member import some XML data into an access database. I am using Office 2003, and the Get External Data command. It successfully imports all of the data, but my colleague says that it is not acceptible because the data...

I think what you might be looking for is the DateAdd function. Your query would subtract 4 days from the [ReportDate] Instead of [ReportDate]-4 try DateAdd("m",-4,[ReportDate]) I reckon that will give you what you need.

Thanks for all your help with the query ecniv. I really appreciate it. I think this might work, but it's not quite there yet. I've had to add filters to the hours and days subqueries to make sure they only get data relevant to the correct year. Also, the subquery to get the band start and end...

It does actually run fairly fast...fortunately its not a huge database...there are just seven different sites using it and each of them will never really have more than a few hundred entries at a time. I'm trying not to think about joins now...the queries for this thing have done my head in...

Well I think that as the main query is slightly more complicated than a normal query, I am going to paste a slightly edited version of the queries here which may get me some better help. I am going to colour code the sections of the query as it is enough to make your head spin. Code for QueryA...

Thanks, but it didn't help. I used Year as an example. It's actually getting the value from a combo on a form. Also, I just noticed that I said QueryA.BandA and QueryB.BandB, etc. It should actually all have been QueryA. There are four columns BandA-BandD in QueryA. I think the main query -...

I am working on a project that requires a LOT of calculation, and I have managed to get to the end and have everything working. Or so I thought until yesterday afternoon. I have a query, that calculates the average number of hours each person has spent in a specific situation per week. This...