Sorry. Yes it was excel!
Thank you xlhelp. I was able to get yours to work... I must be brainless today because I couldn't get Skips to work.. :)
Thanks again!
I am having a problem adding leading zeros to an account. Example:
RTF-123
Should look like this - RTF-00123
RRR-12
Should look like this - RRR-00012
Any help would be greatly appreciated.
Thanks!
I have 2 databases (roles & read only roles). The read only roles contains all the tables from roles (by linking) by in read only view.
The problem we are having is one of the linked tables that has a subdatasheet (another table) in it won't appear in the read only roles with the...
I have 2 databases (roles & read only roles). The read only roles contains all the tables from roles (by linking) by in read only view.
The problem we are having is one of the linked tables that has a subdatasheet (another table) in it won't appear in the read only roles with the...
Hi! I have a table of 700,000 records. The date currently is formatted 5/25/1987. I need the date updated to look like this 05/25/1987. This needs to be done so that I can import it into Oracle.
Thanks!
I have a spreadsheet with the following:
fa1234 6.2
fa1234 3.2
fa1234 2.5
fa1235 9.5
fa1236 1
fa1237 3
fa1237 6.3
I would like to count how many times an item appears in the first column... So it would look like this:
fa1234 6.2 1
fa1234 3.2 2
fa1234 2.5 3
fa1235 9.5 1
fa1236 1 1
fa1237 3 1...
Hi! I am having a problem creating a Duplicate Query(one of the wizard queries) when I have a memo field. I have a memo field because when I imported the excel file into access the field was too big so access converted it to a memo field instead of a text file. If I convert the field to a...
I a trying to create a report from a table that only contains the last 24 hrs. The format of the date is "09/24/2002 9:01:50 AM". The table contains information from the past 5 months.
Any ideas?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.