Recent content by Bobby9779

The $id and $date parts are variables within my php code. UPDATE Temp_Allocation SET Service_ID=$id WHERE [Date]='$date' AND Duty_ID='2' If in access I change the variables to the figures that the variables represent, it works. If I try to run this within the php code I get the syntax...

Thank you lag. I have tried it both ways and it works without on standard queries. There must be something else I'm missing.

Oh yeah, sorry, the error is highlighting FROM!

I am attempting this query and getting a syntax error missing operator and cannot figure out why! UPDATE Temp_Allocation SET a.Service_ID = p.Service_ID FROM personnel p, temp_Allocation a WHERE a.Service_ID=p.Service_ID AND p.Service_No = [Enter Service Number] AND [Date] = [Enter Date]...

Hey, Is it possible for me to make a table and have a column with fixed values. My plan is to have a table that records can be added to (with one column already assigned). The records will be added via a query. I don't know if this is possible, is it possible to have fixed a column that...

It is too complicated to try and explain my full database on here... Is there any way you can add unrelated data in access? I want to run 1 query to get my personnel and then add dates to them. For Week duties there will be 22 people and these need to be partnered up with 22 week day...

I have a query to select people for a duty, based on a ratio I produced given how long they have worked here and how many duties they have done. I need to now add to those records a date, 1st to the 30th of the following month (dynamic), so every time the query is run it will do the next...

My first thread was asking about appending unrelated queries/tables. The SELECT statement I was using created a Cartesian Product, I thought I could get around it using this method. Looks like I can't!

Has anyone got some SQL coding or can anyone point me in the right direction to solve my current conundrum? I need a SELECT statment that selects the 1st record then every subsequent nth record. Any ideas?

Sorry to keep posting, but I am thinking more and more about it and I think I can live with a Cartesian Product, IF I can select from it's outcome, the 1st record and then every subsequent nth record. Any ideas on this?

Can anyone help me with this please? It is driving me insane!

I am after the 2nd querys results with the 1st's results bolted on. So record A from the 2nd query has record A's date from the 1st query. Same for record B, C, D etc. It is based on several queries, based on several factors, so it needs to be able to handle any personnel. My only idea...

I know it is strictly not acceptable from a purists point of view...(Here comes the BIG BUT!). BUT I have two queries, that work fully... SELECT (DateSerial(Year(Now()),(Month(Now())+1),1)+week) AS [Date] FROM Week; Week.week just specifies a list of "increments" not including...