Search results

lagbolt, i have managed to sort it. I added the LogDate and LogTime as one field and ran the query on a new field and this gives my set of results. Thanks for all your help.

Thanks lagbolt for your response. I have tried running that query but it returns no values. Could this be because the Job Started and Job Finish both have dates and times together whereas the LogTime only has the Time Value?

Hi, i am looking for some help in regards to writing a query based on date and time values. I currently have 2 tables with different data and the only thing that matches between the two tables is the agents_id. Within Table 1 I have a Job Start and Job Finish Date and TimeStamp and within...

spikepl, thanks for your response. I will have a look at that.

Hi, i was looking for some help in regards to being able to create forms with multiple forms that will query my database and give the user the ability to create its own reports. I have attached an image of what I am looking to create and was looking for some help, whether this is tutorials or...

Thanks jdraw for all your help, really appreciated.

jdraw i am dealing with Access, as I received 5 spreadsheets which I then imported as tables within Access. I have then ran queries to try and link everything up with join queries in order to try and come up with 1 table. Also I have attached the ERD (no links just highlighted duplicate fields...

Thanks jdraw for your response. Apologies for the confusion. I basically have 5 different tables that each represent a spreadsheet of Queue Names, Ref No from 5 different teams within a Call Centre. Within the Call Centre we have jobs coming through to agents and all 5 different teams have...

Sorry another point I thought of is that the tables already have duplicate fields across each one so thats where I find it confusing of how I can bring about a foreign key in order to make sure I have unique data coming across. Any tips or advice would be really appreciated.

Thanks guys for your replies, it looks like a design issue as I realised that within the four tables I have there is no relationship that I have built within the tables and I have gone ahead and built queries (join queries) that have worked until I tried this query so seems like I will have to...

thanks jdraw, the tables have been designed, the only thing I can identify is that the two fields [F Unique ID] have no relationship between the two tables and I have just created the 2 fields separately. Would it best to have this field as a foreign key from table 1? Btw thanks for the link...

Hi, i am having some problems when combining data from two tables into 1 table. Both tables have a [F Unique ID] field which I have joined but the problem I have is that within both tables I have the Unique ID 000185 that appears 65 times in each table due to other fields having different...

TrevorG, the following are the answers to your questions: 1. The DB and Qs tables show the "Date Added" column, which is the actual date the queue was formed. The WE can be removed to format this as a date, but this is not linked in any way to the Volumes and appears like this from the source...

TrevorG, Thanks for your reply. I will have a look at the database and then come back with a full answer. Thanks once again.

TrevorG, just wondering if you had any luck with my file? Sorry dont mean to trouble..

Trevor, as promised, i have attached a sample database. The sample database shows 3 tables, Qs, Source1 and Source2. I have then ran a union query to join the 2 source tables and then lastly wrote a query (DB) which shows the final table with all the queue information alongwith a weeks worth...

Thanks, TrevorG, will upload a sample within the next half hour or so.

Thanks treor, john and rabbie. To be honest i want to create a database that will not go against the notions of data normalisation. The problem I have is that every week I get a new set of data which I am then looking to add at the end of the master table and then show it altogether. The...

Hi, I was wondering if their is a way to append columns to a table just like you can with rows. i am aware that a join query would work, but i need 1 table to stay static where i can each add an extra column of data that would then show a whole years worth of data. If somebody could please...

gemma-the-husky, combining the 2 results table would be fine, but theirs no link between the two so would it be a case of joining the 2 tables?