Search results

thanks, I have had to use an update query to amend the the week numbers as the table is linked (currently) to various other areas of the business that use the table as a feeder into their data

Good morning all Apologies this may sound an easy question, but I am going round in circles due to "The expression cannot be used in a calculated cell" I have a calculated cell that works as follows, apologies column names arent my choice as it needs to be built so the data output table can be...

Good afternoon, I have created a query that calculates time, but it doesnt appear correct I think. In my source table ([time]) I am calculating the time spent that has been registered for jobs completed in a day, which seems to work but my times calculated together show as...

Thank you @Minty I have updated the code as per below, but I get a "syntax error in the FROM clause" is there any easy way to see what I have missed? delete * from All_data; INSERT INTO All_data ( DateTag, SessionIDTag, DNISTag, CLITag, LOBusTag, SegTag, ICMTag, CountTag, PrompSTag, AppTag...

Good afternoon, I am new to SQL and I have jumped I think in at the depend end. I have a table called "All_data" that I want to populate from weekly tables (44 & 45) All data has 27 columns but my data in Week_45 start with partial data and can complete up to all columns by the end of the week...

Is it possible to send a file to you through this website without posting it online? The simplist way is probably to think of it as 1 form instead of 2. ie fill a number press submit and it opens another userform. I have a field called ref no, then the relevant fields that need populating...

Thanks for the file you sent, but i have 1 question if possible. I think i understand how your file works loading another userform, but is there a way i can do this without loading another userform. As in i have the reference number and then the fields to populate below it on the current...

Thanks for this, Would i enter this in the control source in properties. Also how would this reference my data table? Sorry for being a pain, just trying to understand where the information is from? Thanks Gavin

Sorry, My table name is Data with columns [date],[developer],[RefNo],[Prop],[Criteria] The form i am lauching the search from is "frmAgentWorkToDo" and cell reference Text41. I have created the button to open the correct form which is "FrmUpdate" When the form is loaded i need the...

I have a database with information in and a column headed reference. On my userform i want to be able to enter the reference number ( tab out or run a macro) once this is done the information in refernce to to the number is pulled in. ie the date is to be populated in text2, from column [date]...

Good Afternoon, I am new to access and am a bit stuck. I have a userform i want to populate once a reference number has been entered into a unbound textbox. Can anyone point me in the right direction to create a macro that will pull the data out of my database? sorry if i am being vague...