Search results for query: *

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...

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],"...

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...

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.

I have a table that has 10 records in it with a quantity feild I need to create that record that many times. Field1 Field2 Qty 001 Dog 10 002 Cat 5 I need to have an output file that will have Line 001 10 times and line 002 5 times to export to excel.

I need to be able to bring in any type of file in access, and print a field layout, quick and easy. Is there a way to do this. Example: Field1 1 30 Field2 31 60 Field3 61 90

I have a database with the names in 1 column, is there a way to parse these out? Column 1 Mr John Brown Jr. TO Expr1 Expr2 Expr3 Expr4 Mr John Brown Jr.

How can I select a group of records from a table that includes the ";" in a specific column. Example: Column1 Column2 David 978-555-5555 Tom;Harry 617-555-5555 I would only want to select the second record. Also is it easy to change this to select the one...

First page code <CFFORM format="Flash" width="500" Action="Results.cfm" Method="Post"><br> <p> Enter Player Name <CFinput type="Text" name="Playername"> </p> <p> <CFinput type="submit" name="Submit" value="Submit"> </p> </CFFORM> Second page code <cfquery name="Score" datasource="Nascar">...

Ok I have a table that looks like this. Name Row Section Price Ryan A 12 $10 Ryan b 12 $10 donna C 5 $20 donna g 6 $40 I need to creat a query that will group by name (keeping only one record) and combine the...

Is there an easier way to do this? I have a list box and a button that will work of the selected box but there are a ton of entries.... If Me.ListContact = "Alphabetical Customer Listing" Then DoCmd.OutputTo acOutputReport, "rptAlphabeticalContactListing", acFormatSNP, , yes ElseIf...