Search results

Hello- I have a query that pull data from hours worked fields that have values with decimal places. Hours is multiplied to rates to create my amount to charge in my query which is then displayed on my invoice report. The issue is that when I sum my amount, my subtotal is off by $.01 due to the...

Hi Beetle- Thanks for the reply. It appears that I need to export to an Excel file instead of a .csv. I did test the DateValue format and the format comes out as dd-Mon-yy. The month is the 3 character abbreviation. Is there anyway for the date to display mm/dd/yy? Thanks- anissw

Hi David- I apologize for getting back to you so late. I will give this a try tonight and let you know how it goes. :)

Hi David- Thanks for replying. I do need the original record for conducting invoicing/billing. The original table is updated from the raw imports that runs on a task scheduler every night importing data from another data source. Orders from those raw tables are imported for previous day...

Hi- I currently have 1 form linked to 1 table which data from another table is appended to for editing, re-appended to original table and then rows are deleted. However, this process will need to be done by 4 other users soon and I needed to know if I need to create 4 separate tables and 4...

Hi thechazm- Thanks for replying. After a good night's sleep, it had come to me to use the requery option in VBA. I have created test database of my current database and have posted for your viewing of what I finally did and it worked perfectly. :) Please review and any additional...

Hi- I have 3 combo boxes for selecting clients, start and end date ranges. I created an indicator to flag true if I have used a start and end date. However, i need to include the client combo box as well. The process should be select client, select start date, select end dates. Restriction...

Hi- Does anyone know how to have a csv format with the fileds of date to display only my date field instead of datetime field? I tried CDATE and when I review my output, the format is still datetime. This export is from within a query I created. Thanks- anissw

Hi John- I came across another dilemna. I have a query that is accessing another query for total of rows grouped by account number. E.g. The query is displaying 3 rows, however there are 2 values for account number. The total will display 3 instead of 2. I tried the DCOUNT syntax and the...

Hi John- Thank you so much!!! :) It worked like a charm!! Sorry for the delay in replying.

Hi. Thanks for answering me. The tables are a bit complex in theory in which my calculation from the raw file is setup to calculate several different scenarios of order processing quantities (orders, addtl items, extra pkgs, etc.) So far, there are about 17 different fields that can be...

Hi John- Thanks for replying. I'll test it and let you know how it went. :)

Hi. I have multiple conditional statements in order to define Quantity and Access only allows 255 characters for the expression builder. How do I setup my function to define quantity based on the multiple conditional statements I need to implement? The quantity field name I have is based on...

Hi. I have a table that I have created for generating invoices. My program and codes work, however, I need to include a row counter for the invoice table. So far, when I initiate a count using DCount, it will generate the count of total number of records, (17 records in a table for each record...

Oh my goodness, it worked!!! Thank you so much. :) :)

Hi. I have a form that have 2 combobox for date value ranges (CboStartDate and CboEndDate). My query generate order based on these dates ranges with no problem. I need to have 2 fields created in my query (WeekBegin and WeekEnd) with the values from the combbox start and end dates. So far...

Thanks so much. I was able to get it to work.:D

Thanks so much!! :) This was just what I needed. The master invoice table will provide a list of invoices generated to for validation or means of regenerating an invoice per request. I couldn't tell if my CustomerDetails query would work in this process and was stuck trying to resolve it...

Hi Thanks for replying. Do I add at the end of closing my macro or where the report preview begins?

Hello- I'm trying to open a report from a button on a form in preview mode. When the report opens, the option to close print preview, pdf or xps, etc on the top nativiation pane is locked not allowing me to export to a PDF, change orientation, or print. I have to go to Window and then select it...