I trying to create a table using visual basic, when i try to run it. It
prompt me "No fields defined, can't append Table or Index. Anyone, could
highlight to me what is the problem. My code is as follows:
Public Sub PCreateTable()

Can someone email me a small sample database that reflects a yes or
no
answer to a group.  like if i want to know how many 35, 36, 40 yr
olds

Would like a Error Message to appear when a query returns null

Hello, I am building a parameter query that uses a form to fill in 3
criteria. The criteria are Physician Name, Start Date, and End Date. The
physician name is a combo box and I have added the IS NULL to the OR part of
criteria in case the combo box is left blank. If left blank, ...

I have the following query:
SELECT CityID, Age, Sex
FROM PDL
GROUP BY CityID, Age, Sex

I am trying to sum to fields from two separate queries. I have tried
adding them together (you know, [field1]+[field2] as well as [table1]!
[field1]+[table2]+[field2]) but that isn't working. Instead I am
getting two rows of data (one is field1 and the other is actually the

I've run into a serious problem with memo columns being truncated. Whenever i
do a SELECT Distinct or a UNION query my memo fields are truncated.
My database as a table called Issues which has a memo column. Issues are
assigned to Rules and Rules assigned to Packages. The same ...

I have a table with a field SVCCD, and I only need the information from the
left to the - and from the right to the .  See below for examples
SVCCD                                Needed Information
01-30000.002-0110                   01-002-0110

I work for a small mail order company and I'm trying to get a estimate of
our shipping costs.  If we get a order for 6 items and we only have 4 in
stock, we will ship the 4 and backorder the other 2. The table structure
looks like this:  Order#, Weight, ShipDate, Cost.  I need a ...

I have a query that reads parameters from a form.  The form contains several
unbound controls and two buttons: one to run the query, and the other to set
the value of all of the controls to Null.  I've debugged the "Clear values"
button, and all of the controls (text and combo ...

I have a parameter query that queries the month and on a day of the month
range. I’m using the following in the query:
WHERE (((DatePart("m",[Doh]))=[Enter a Month]) AND ((DatePart("d",[Doh]))
Between [Enter a start day] And [Enter an ending day])

I have a query that shows several fields (ie. first name, last name, acct #,
date, address, value). I would like to create a form whereby the user would
select only the fields (by selecting the approriate check box) they would
like to see once the query is ran. For example, a ...

I'm using QBF with about six different combo boxes using:
[forms]! [formmain]! [combo1] or [forms]![formmain1]![combo1] -like in a VBA
book.  This is so users can select criteria on a form with the combo boxes,
and when they are done, they hit the search button, and it opens up ...

I have two tables as follows:
workorderentity1
workorder,entityuid,entitytype,feature_id,feature_type...
and

I have a query that currently looks like this:
SELECT district, account, name
FROM DNSData
WHERE district in ("Districtname",etc)