russhenry715
-
Automatic Numbering Issue
Good Morning, I have automatic numbering working on my database but i need to see how i can improve Here is my current number . (Year - Job # - Auto number-001) 2019-522-001.001 2019-522-002.…
-
Report Style
I have a report that shows current questions and responses i have sent to an customer. Is there away to style the entire row if the response date is null?…
-
Auto Numbering Issue
Good Morning I have a table that i keep all my work orders in and i have one table that i keep all my product submittals in that it autonumbers when i link them together.…
-
How to style Date/Time
I am trying to style my auto created date/time stamp so it only shows the date and not the time. what is the proper code for the fomula? text('Created on')
-
Pie Charts
Is it possiable to show the dollar amount? I have a chart that shows my base contract and my change orders
-
Re: I need to see if a value = something from combo box that it will create a new event in my history table. Currently i have a project table and when i select "PENDING" i want it to create a new event in my history "New item pending"
Ok what is the proper way of adding a new row in a seperate table? if text(Status) = "Bid" thentext(History.'Create New Event') = "Project move to Bid Status";text(History.Date) = "now()"text(History.… -
Custom Stamp
I am working on creating a stamp for a report and i want to be able to put an "x" on the printed report if a value = I have a combo box where the values are stored just not sure how to code this one…
-
Number Questions
I have a main "Projects table" that i have a relationship with my "Punch List table" and want to generate auto number but add the "Id" from the "Projects Table" Currently i have the auto number…
-
Projects
Hello. I have a main table called projects and a sub table for my submittal log and i want to know how i can autogenerate submittal numbers? They are 3 digit and every project starts at 001 my…
-
Database
I am trying to keep track of my milleage between jobs and want to know how i can subtract from starting to ending milleage. Also is it possiable to reference a field from a different data base?