Search results

I am pulling through data from a table that formats the date in yyyymmdd format. I need to reformat the date to mm/dd/yyyy. I'm having an issue pulling through the date formatted to mm/dd/yyyy in a report because the field I am pulling through does not always contain a date. What formula...

I've created a query that is pulling data from a table that I created as well as from 4 tables from our software database. The data runs just fine, but when I try to export it to a .txt file I receive the error: Too few parameters. Expected 2. After switching some stuff around I then received...

Hi, in our system we enter notes and I am looking to extract those notes. The notes are encoded in as RTF and I need to strip that data. I need the data after fs20 up to \par. Below are some examples. The data I need is in bold pink. What formula do I use to do this...

I created an Access database - only myself and one other computer in our network can open the database. When other users open the database, Access opens to a blank screen. Within the database I have a number of tables and queries setup. Do you know what would cause this to happen? Is it a...

See attached file -- I need the information on the IMPORT3 tab to export from Access like the data in the FINAL tab. If the line has a material charge - I need a new distribution line using the MTL debit and credit codes. If the line has a freight charge - I need a new distribution line...

I am overthinking this and need some help. I'm trying to filter my query to not pull a few different values from one column. When I enter thee criteria Not Like '*25*' the query does not pull through rows that have 25 in this column. How do I tell it to not pull multiple numbers? This is not...

Is there a way to calculate the mode value in a query? In a summary query, I need to return the value that shows up the greatest number of times in a certain column of a table. Is there a function built in to Access or an easy way to perform this, or do I have to make my own function to...

I currently have a query pulling the date field as a text field in the format yyyyddmm. I want it to convert to mmddyyyy. Ive accomplished this by using this: ETA: Format(CDate(Format([PromiseDate],"0000-00-00")),"mm/dd/yyyy") This works great except when there is nothing in the PromiseDate...

When using the carriage return how do I format the data so it will export with 2 decimals? In the example below I need the Estimated Material Cost to export in in format: 500.00 --- NOT 500. MTLCost: [Estimated Material Cost] & Chr(13) & Chr(10) & [C] I appreciate your help.

I currently have a query pulling data from a database - I need to now export the data to a text file to import it into a different database. I need the format to be like below. Wondering how I can tell the query to go to the second line and then the third line like below. *,9215146,BUILDERS...

I've created a form that prints a report created from a query. I want the form to have two print options - to either print by Date OR Job # and I want the data pulled from the same query. Right now I have the criteria setup in the query for the Date and Job # fields to: DATE: [Forms]![Job...

I need to write an expression that does this: If field 1 = WARRANTY and field 2 = 17 then field 3 = WARRANTY GB, If field 1 = WARRANTY and field 2 = 18 then field 3 = WARRANTY N, If field 1 = WARRANTY and field 2 = 19 then field 3 = WARRANTY C, If field 1 = CLAIM and field 2 = 17 then field 3...

I have imported a spreadsheet and then created a query - in the query I am trying to format the data. In my spreadsheet there are two fields that a job number can be in. If there is a job number in the Job_Num1 field I want it to pull from there, if there is not a job number in the Job_Num1...

My report is grouped by a Billing Group #...within each billing group there are sub invoice numbers that are tied to the main billing group # (they all have the same billing group # but different general invoice numbers). I need to pull data if one of the general invoice # invoice dates is...