Search results

the problem is that i can only use it as a linked table (and i can't change the format of the fields). if i don't use it as a linked table, then when i import it i get weird characters in front of the data, but in excel it is fine. strange.

i have a linked table that where all fields come in as text. my question is about the date which is either 2/12/02 or 2/2/02 or 12/2/02. i need the date of the month. i can't use the mid function because of the different placement of the date. any suggestions?

i need to be able to figure out the next billing date. (monthly biling) i have the effective date and i need a report to show when the next billing date is. i will be basing this on the effective date. i figured i need to figure out how months the account is active and then add that to the...

i have a report that has 2 pages for each record. i know i could put in a page break and then make the second page. the problem is that on the first page i have a page footer that i don't want on the second page. i put in a page footer becuase i want certain info to be in the same spot on each...

I need to send a file in this format: "1""name""credit card""exp""amt" how can i convert the query with 5 fields to this format?

I would like to get the total # of active members per month, for each month in the last 2 years. i have their effective date and some have a cancel date. (those that don't have cancel date are still active). So if someone became member in June and canceled in November, he was active for June...

i have a date field that i want to add a number to. this works fine. NEW END DATE: Format(DateAdd("m",+[payment schedule],[PAID THROUGH])) but i want to see it as May 1, 2001 not 05/01/01. how can i do that?

thanks! that makes sense, but i was hoping to get a quicker way, in 1 macro. but this will work.

I receive a file every morning with addresses. the state is written out, not in the state postal abbreviations. i am looking for a macro to change the state from "Virginia" to "VA". any suggestions?

i have a list of members and their begin dates and some have end dates. they pay once a month - each one can be on any day of the month. i need to figure out how much money we billed on each day and how much we actually received. the received part, i more or less have. i want to get the billing...

i would like to create a query that pulls all records that have a number in any position in FIELD11. how can i write that?

thnaks for the prompt reply! i'll try that.

i have a query that requests a date to generate a report. right now, it has the generic message "Enter parameter value". i would like to make my own message. How can i do that?

i am looking to write a macro or some coding to import a text file. i have a file in btrieve that may be changed every day (address changes, etc) i would like to delete the info that was valid after the last time i imported the data and put in the data that was valid as of last night. i can do...

i need this because i am sending a file to a program that uses house numbers to verify the account number i am debitting from. the program only accepts numeric characters in that field. it is better to leave it blank than to put in letters. (it is only one of the verifications - there are others).

what about 19-34? the val("19-34") gives me 19. i need it to be blank or 1934, not just 19.

i need to take the house numbers from the address field. if it is a PO Box or the address has a hyphen or letter, i want the field to be blank. i tried this: addr: Left([address],InStr([address]," ")-1) that gave me whatever was put in before the first space. it did include the PO and...

works great! thanks!

i need to remove all dashes & spaces from a field. sometimes there are spaces, sometimes not. i would like to do this from a query because i will be exporting the info to excel from the query.

i tried this in the query: first field step1:right([csz],(instr([csz],",")+1) next field: step2:mid([step1],instr([step1]," ")+4) third field zip:left([step2],5) this gets me the info i am looking for. thanks for your inspiration.