Hi Achi, 1. Do not store the NextDate in the table. 2. Use a Query based on the Table as the DataSource for the Form. 3. In the Query, add a CalculatedField...
Everyone is telling you that if you can calculate a value from a field in the table, there is no need to record the calculated value in the table. You can...
Make a field "Repairing date" in your table and add what ever fields you need but DO NOT MAKE A NEXT REPAIRING DATE field. Instead show a calculated field...
Hello Access_Professionals, Where does the Add-In Manager get the file name? I've renamed a MDA file, and changed the project name in the Tools | Options |...
Hi everyone, it is clear enough. Thanks a lot. Sorry to put you in trouble by answering my questions. Achi _____ From: MS_Access_Professionals@yahoogroups.com ...
Hello Greg, ... Go to File | Database Properties | Title box from Access's main menu. Thanks to another source. Not to answer my own question, but I thought ...
Dear All, I have a question, I would like to make a repairing schedule from January to December. Can anyone help me how to make it? where can I process the...
Greg We always appreciate it when someone posts an answer even if it is to their own question. Thanks for taking the time to do so. Regards, Bill Mosca Founder...
I am trying something which I thought was going to be easy to do but it turns out that it is not working for me. What I am trying to do is to create a master...
If you are repairing every six months, then use a calculated field that adds 180 days to the repaired date and sort on that filed in ascending order. When the...
Dale- When you have difficulty making Access do something, it often is a problem with your table design. It sounds like you have four tables - clients and ...
Achi, Paste this in the SQL View of a query while in Design View. You will need to change DateField to your date field’s name, and TableName to your table ...
It's not working. I have like this SELECT Month([Date Of Comm]) AS [1] FROM TBL Commissioning GROUP BY Month([Date Of Comm]); But it is not working. _____ ...
... From: John Viescas To: MS_Access_Professionals@yahoogroups.com Sent: Saturday, December 31, 2005 2:32 PM Subject: RE: [MS_AccessPros] Query And Report...
Hi John, thankyou very much for your reply. Here is what I currently have at the moment. SELECT sholasc.Ward, Sum(sholasc.Dwellings) AS SumOfDwellings,...
You cannot have a space in your table name. This might work: SELECT Month([Date Of Comm]) AS [1] FROM [TBL Commissioning] GROUP BY Month([Date Of Comm]); Or...
No reply included - did you hit send too soon? John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running...
Lewis- Not exactly. What is "PPG Group"? What is Ward? If you add another field and don't specify an aggregate, you should see additional rows produced - ...
What I have is a table called clients, one called ISC (independent Service Coordinators), Counties, Provider Agencies, Domain F, Domain M, and Domain P. The...
... From: John Viescas To: MS_Access_Professionals@yahoogroups.com Sent: Monday, January 02, 2006 12:59 PM Subject: RE: [MS_AccessPros] Query And Report Design...
Hi John, to answer your questions. What do I want to see ? I wish to see a number of outputs in the report. 1) The number of brown field developments. 2) The...
Dale- Are F1Y, F1N, F1NA, F2Y, F2N, F2NA, ... etc. all fields in one row? If so, you have a table design problem. Your Domain F table should look like: ...
Lewis- It would be useful to know the structure of the sholasc table - including a description of what is in each field relevant to this problem. A couple of ...
F1Y, F1N, F1NA, F2Y, etc are all each separate fields in the table and they are listed as Yes/No datafields. When the form is filled out there should only be...
Lewis- OK, I see Ward, PPG3 Brown number, PPG3 Conv number, PPG3 Green number, and Urban Vac number. What is the meaning of the values in PPG3 Group? I see 9...
Dale- As pointed out earlier, your table structure is wrong. You need one row per ClientID and question number - and the data fields should by Y, N, and NA. ...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
