Search results for query: *

The field Names and Number of Fields change every time. I am also using the table to print a field listing for a report as well so keeping the names Field 1 through whatever might not work the best... Thanks again guys, might just have to suck it up..

Well I have been using the Report Wizard to create it each time, but would like to cut down on time , and make this automatic if possible.

I have a report that I need to create that is going to be a data dump of 25 selected records from "tblImport", but my issue is the fields are going to change in this table daily. This will select my records and fields, but need a report to be displayed off of this query without having to...

I have a database that will have a file imported multiple times in a day to be ran through some queries. This file will be different every time. I have a query that selects a random 25 records for a data dump but what is the easiest way to create a report that will change with the new fields...

Thanks guys.

I am looking to parse names that go into a table in the field "FULLNAME", but I only want this qry to run if there is 1 space in the field. UPDATE tblStandardLayout SET tblStandardLayout.FNAME = Left([FULLNAME],InStr([FULLNAME]," ")), tblStandardLayout.LNAME = Mid([FULLNAME],InStr([FULLNAME],"...

Thanks alot, works great.

Wish I new how to create a table from this or I would. Thanks again guys.

Thanks but this is something that I would like to add to a macro to be ran at the begining of a job.

This gives me a layout of a table in the debug screen. How can this be alterd to show in a report? Public Sub fieldProperties() Dim tblStandeardLayout As String Dim rs As DAO.Recordset Dim fld As DAO.Field Set rs = CurrentDb.OpenRecordset("tblStandardLayout") For Each fld In...

That is exaclty what I need but not getting it to work. Thought I did. Sorry.. How do I use this on a table called "tblStandardLayout" ?

Thanks alot.

Can this be done in a Report? This way I can see counts on multiple fields instead of running multiple queries? SELECT Len([COMPANY]) AS Length, Count(tblStandardLayout.COMPANY) AS CountOfData FROM tblStandardLayout GROUP BY Len([COMPANY]); and SELECT Len([TITLE]) AS Length...

Thanks alot.

Thank you that is perfect. Is there a way to get counts of a field. Say I run a query on the company field and i want a layout something like this. Where length is the number of characters and count is the number of records that are that length. Lenth Count 10 1 20 5 30...

Is there a way to get charater counts of a feild in a table. So if I have a company feild I want to get a count on how many are under or over 50 charaters long.

Works Great, Thanks alot guys. Saved me alot of time.

Thanks , but I get a runtime error 13 on: Set objSourceRS = CurrentDb.OpenRecordset("Test") Type Mismatch.

Thanks for the help. I guess this is a lil bit over my head. Hours of Cut and Paste will have to do the trick.

How do I take that table using a query to output a new table with the feilds multiple times based off of the quantity field?