Search results

  1. V

    Getting data from a week and also that same week in previous months

    if my week like I stated was aug 18-24 the previous week in the previous month I would want is July 21-27 im not sure where you are getting march from because ive never stated anything about march?
  2. V

    Getting data from a week and also that same week in previous months

    for july the week would be 21-27 june would be 16-22
  3. V

    Getting data from a week and also that same week in previous months

    I have an issue with some data im trying to get here is my scenario we'll use the week of august 18-24th for my example the user will want the data from this week, but also will want data from the similar week in previous months. right now im getting the current week of the month so this week...
  4. V

    Query Access table in SSMS

    Heres my scenario. I have an access table called Innovative in an access database. While on the server i can query this SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', '\\vq1\Efile Document Storage\HR\HR\Employee File Notes\Employeefilenote.accdb'; 'admin';'',innovative); so i have...
  5. V

    Creating a report using multiple queries

    All the queries have the same exact fields, but each query is different because im summing up some costs pertained to a range of miles on a truck.
  6. V

    Creating a report using multiple queries

    IS there an easy way to create a report that uses multiple queries?
  7. V

    Mulitple Queries into 1

    All i am finding is union queries where you union by table name, nothing about union multiple queries, can you give me a example please.
  8. V

    Mulitple Queries into 1

    I have 10 queries, everyone has the same exact fields. Each one is named qry_0-100000, qry_100000-200000, ect all the way up to 1000000. In each query i have trucknum, sumofparts, sumoflabor. What its doing is summing up all the parts and labor costs for each truck in the specified range of...
  9. V

    Help subtracting on a form

    I have a form that has 3 filed from a table. they are total_cost, Labor_cost, and Parts_Cost. I want the user to type in the total, and labor, then calculate it so that it takes the total-labor to give me the parts amount. I cant get it to subtract them. In the parts textbox i went to the...
Back
Top Bottom