Search results

Hey guys, I would like a filter that when I sort ascending, will put the values in order(1,2,3..) be it in a table or query. Thanks!

I have 6", 36" and 42" pipe that is welded together. I want to show the total of welds completed per size between certain dates. I have a query that seperates it out by individual date but i just want a total between a range of dates. Thanks.

Hey guys, I need to calculate the percentage of rejected. I have a column for accept and one for reject. I want it to count when true in accept and reject, when i try this it shows up as a negative value? Any idea what i doing wrong? Thanks.

Hey guys, I have a table for qualifications, there is a column with expiry date. I was wondering what criteria to use in a query that would show only those qualifications expiring within 30 days. Thanks a lot.

Hey guys, I am having trouble with my report. For 1 the gridline thickness is inconsistent, the sides are thicker then the top and bottom. Also, I am trying to get the grid to look like one you would find in excel but there is a gap between the top and bottom of every row. If you know hoe to fix...

Hey there, I am trying to make a query that utilizes check boxes. My code looks like this: SELECT DISTINCT [TRO SCOPE 3].Weld_No, [TRO SCOPE 3].VT_No, [TRO SCOPE 3].VT_Accept, [TRO SCOPE 3].VT_Reject, [TRO SCOPE 3].VT_Repair FROM [TRO SCOPE 3]; VT_Accept, Reject and Repair are all check...

Hey guys, here is the code i am working with so far: SELECT [TRO SCOPE 3].WELDER_ID, Count([TRO SCOPE 3].WELD_DATE) AS WeldsCompletedtoDate, Count([TRO SCOPE 3].RT_DATE) AS RTCompletedtoDate FROM [TRO SCOPE 3] GROUP BY [TRO SCOPE 3].WELDER_ID HAVING ((([TRO SCOPE 3].WELDER_ID) Is Not Null) AND...

Hey guys, I am trying to rename a table. In the navigation pane it shows up with the correct name but when i open the table the tab on the top still shows the old name and when i try to print the old name shows up. Any idea how to fix this issue, thanks!

Hey guys, how do I remove or change the color of the underline that is present under the column headings in my report. Thanks.

Hey guys, I am first going to explain what I am trying to achieve then tell you what I have, Tasks are performed by multiple People, overall 20% of each Persons Tasks has to be tested. However the Tests have Categories (qualifier 1 and 2, original, repair, rework etc..) and the first 2...

Hey there, I need to count 4 different totals. Using 4 categories and only unique values. I was wondering if I could do all 4 in one query. Thanks

Hey there, I need to include in my report a text box that counts dates. There will be multiple entries of each particular date but it only needs to be counted once. What formula would I enter. Thank you.

Hey guys, I would like to display two dates in my report header to show a reporting period. Thanks

Hey there, I am required to submit reports on my accumulated data every 2 weeks, I was wondering if tehre is a way to insert a report # in the header that will automatically update itself. Thanks.

Hey tehre, I was wondering how to insert a solid border around my entire report. Thanks

Hey guys, not sure of the best way to go about this. I have several workers assigned to one job. While on the job their tasks are randomly tested. There is criteria that states each worker must be tested a certain amount. How can I calculate the percentage he or she has been tested based on the...

Hey guys, not sure if can be done in a query or not, I have ID's which need to be linked to a specific type of testing that took place on a job to find the percantage. If you understand what I mean and know how to achieve this please let me know. Thanks.