Hello,
I am trying to create ID tags with Avery business cards from an Access report. Below is the code for the Name fields. How can I get a space to appear between the first and last name?
Thanks so much, Nancy
=Trim([FirstName] & [LastName])
Hello,
I've attached a (censured) database I'm working on.
In query qryBrochure, none of the fields from table tblIDArtistInfo will populate. I can't figure out why???
Thank you, Nancy
Hello,
I have created a combo box with 3 columns; ID, LastName, FirstName.
I want the user to be able to search by the LastName, but have the ID entered.
What settings in the Property Sheet would accomplish this?
Thanks, Nancy
Hello,
I have a table that list each batch that was produced with a ProductNumber field. I want to create a qry or report that counts the number of times each ProductNumber was entered. I need to know what batches are made more frequently.
Thanks, Nancy
jd,
thanks for this attachment. Ill study it more thoroughly and consider it for future databases, but some of the fields I'm have a problem with are not calculated fields.
Nancy
Pat,
I am attaching the a copy of the back end tables I named 'NonCon_Copy'. I have removed all text fields so I could attach the database.
Other tables in the db work ok (which I also removed).
The fields I'm have a problem (getting totals) with are in the table GelProductionWaste; fields...
Pat,
Thank you for replying! I understand every thing you said and I'm fairly sure I'm in compliance. What is strange is I can get the other functions (such as AVG) to return a value but not SUM. I have to export any sorts I do to Excel to get totals of my fields.
Nancy
,[Batch Size]
,[Theoretical Lbs]
,[Partial Lbs]
These are a few of the number fields that should return a sum.
I noticed a few other things:
In the _be table, I tried to change the formatting and decimal places on some of the number fields, but the properties will not take affect.
I made a copy...
It looks like I had a query after all: and thanks for your help and patience's!
SELECT GelProductWaste.ID, GelProductWaste.[Part No], GelProductWaste.[Lot Number], GelProductWaste.Description, GelProductWaste.[Batch Size], GelProductWaste.Silica, GelProductWaste.[Theoretical Lbs]...
Actually, I am using a datasheet form to work with the data, but neither the form or the table is giving me a SUM. I'll create a query from the table and try that.....
Thanks, Nancy
This is not a query. It is a table with several number fields. I am clicking on the Total button on the Menu bar which displays a Totals row at the end of the records. When I click in the cell for which I want the SUM, the other functions work (such as COUNT and AVG), but not the SUM function.
Hello,
I have a table in my data base with several number data type fields. For some reason I can not get the SUM to return a value on any of the number fields. The COUNT and Average works, but not the SUM. Other tables in the database work fine. Is there a setting or something I am missing...
Plog, I did some research- turns out I had to remove the semicolon in the FROM clause.
It works perfect. I think this will help me out. Thanks much!!
Nancy
First I tried the brackets- didn't work, so I fixed the field name- no spaces, but now I am getting the following:
The LEVEL clause includes a reserve word of argument that is misspelled or missing, or the punctuation is incorrect.
SELECT LotNumber, MAX(DateStamp) AS LastEntryDateStamp
FROM...
Plog, I decided to do what you suggested originally and extract the Lot Numbers I need first. Here is my SQL code, but I'm getting the following error when I run:
SELECT Lot Number, MAX(DateStamp) AS LastEntryDateStamp
FROM tblUpdateBatch;
GROUP BY Lot Number
Syntax error (missing operator)...
Thank you Plog,
Sorry for not getting back sooner. Below is my SQL as it is now. I have a criteria in one of the fields. Where would I place the code you suggested in this SQL statement??
SELECT tblStartNewBatch.[Item Part Number], tblStartNewBatch.[Lot Number], qryDescByLot.Description...
Hello,
I have a table for entering the status of a production batch with a DateStamp (Now() criteria) field, and a LotNumber field (which will contain multiple entries of the same lot). I want to run a query the returns only the latest entry for each lot. Any Ideas. I'm not good with VBA. I was...