Help With Date And Location Query
May 25, 2006
Hi all....
Preface: Main table called tblMain. Here are three of the fields that I am interested in setting this up for.
tblMain
Field 1: [IncidentDate]
Field 2: [Address] (actually street numbers)
Field 3: [CityStreet] (actually street name via lookup field off another table)
Query based of the above tables.
What I want to query is this:
If location has an entry on July 4th, 2006 then it counts it, if the same location has has another entry it counts it. If it only has a incident on July 4th, 2006 an no other prior incidents do not display it... Does this make sense.
So it would look something like this in a report generated off of the query.
07/04/06 123 Main St
07/03/06 123 Main St
05/05/06 123 Main St
07/04/06 125 South St
07/02/06 125 South St
06/22/06 125 South St
Thanks
R~
View Replies
ADVERTISEMENT
Sep 6, 2007
hi everyone,
I have a table with persons age and location and I want to generate a report of all persons by location and age group. The age groups are 0-9, 10 - 19, 20 - 29..., 90-99.
The location codes are 10,20,30,...90,99.
Any suggestions?
Many thanks
Will.
View 2 Replies
View Related
Sep 16, 2014
I am attempting to build a small database for my firm to keep a track of equipment. The equipment can be in one of three places. In the warehouse, out on a job or at the repairers. I want to create a query that will let me know where a piece of equipment is at any one time. I'm sure my tables are set up correctly. I have use a union query to work out when equipment is on a job or in repairs but I need one to show me where all the equipment currently is.
View 1 Replies
View Related
May 23, 2013
I have a query that combines few different tables in order to create a View (Query) that is then used to by and Excel sheet to update a list. The Excel is dynamical updated when new data is inputted in the Access Tables.
But one of the fields in a query is combination of path name and report name (another filed in one of the tables) that crate a complete path to a file that contains some additional information.
Now since the Excel is updated dynamical and users of this Excel sheet are not very advanced. I waned to make it easy for them to just click on the location of the file and the file opens up. But I am not able to make the Query that contains the file destination hyperlinked.
I am using Access 2007
View 2 Replies
View Related
Jun 25, 2015
I am trying to export a query or table to a location that the user selects. So each time the export button is clicked the folder will change. But I want to be able to select the folder.
The code I have below is saving but not to the folder I want it to.
Private Sub CommandBtn_Click()
Dim fileSelection As Object
Dim strPath As String
Set fileSelection = Application.FileDialog(4)
With fileSelection
.AllowMultiSelect = False
If .Show = True Then
[Code] ....
View 1 Replies
View Related
Aug 19, 2015
I have a table that has entries recorded with date and time in one field, and I want to have a query that returns all records of a specified date or date range, regardless of the time in the field.
I have tried
Code:
Between [StartDate:] And [EndDate:]
And
Code:
Between [StartDate:] & "00:00" And [EndDate:] & "23:59"
Neither of which work ....
View 13 Replies
View Related
Sep 3, 2005
Background:
I have a database that keeps track of containers -what they belong to, and what is in them. Each container has a “Call #” which is labeled on the container and is a primary key in the database. The “Call #” field is set to only allow 5 characters in this field. A standard “Call #” for example is "A 152".
When a new container comes into the system, which has not been physically labeled yet, I enter it in the database a little different. So let us say container "A 152" just came in, and has not been physically labeled yet. I enter the “Call #” into the system as "MA152". The "M" tell me it still needs to be physically labeled.
When I go to label all the unlabeled containers, I print a report with all the "Call #''s that start with "M".
I have another field in the same table called "Mark". In my forms I can then go through and click a "Mark Button". The Report prints all containers where the "Mark" field = yes(True). This feature is used for a number of different reports, not just unlabeled containers. To keep the database clean and in order, all “Mark” fields reset to no(false) whenever it opens up.
Because, I used the “Mark” field for other reports, simply clicking the “Mark Button” when I enter the new container into the system will not work.
My Question:
Is There a way to have a Query search for the first letter in a field. So when I go to print my report, a query runs looking for all "Call #s" that start with the letter “M”.
View 2 Replies
View Related
Jul 20, 2006
Hi folks,
I have 50 locations spread over the UK and each site has a red, amber or green status based on several criteria. What i want to do is have a form with a map of the UK and have each location represented on the map with it's red, amber or green status based on coordinates in the country i guess.
Thanks
Mark
View 4 Replies
View Related
Mar 24, 2005
How do I find the file location of the current database?
View 2 Replies
View Related
Nov 8, 2006
Hi all.
I have been working on an Inventory Database over the past few weeks and I have run into a problem.
Currently I am designing the database to use the common way to calculate on-hand inventory levels (Latest Stocktake(cycle count) + Received - Used). The problem comes when I am trying to calculate this value.
A solution that seems to work is to take stocktake for a given product using the ProductID and date. I have a child table linked to this one to show the quantity and locations of the product. However, with this method, I will have to count the inventory for every location the product is in when the stocktake is taken. This method may work, but accidents may happen and an employee may forget to count both locations when taking stock. Then current inventory levels will be way off.
Is there an easier or more efficient way to do this?
Table Design
-=-=-=-=-=-=-
tblStockTake
StockTakeID
ProductID
Date
tblStockTakeDetails
StockTakeDetailsID
StockTakeID
Quantity
Location
View 2 Replies
View Related
Aug 16, 2007
Okay trying to get at an mdb that I have copied from the live network drive onto my own machine. Each time I try and look at a table in design or data mode it keeps trying to locate the table on the network drive.
How do I tell access to look at the copy on local drive? Using version 2003, and don't remember this issue from version 97.
View 4 Replies
View Related
May 23, 2006
Hi,
I have been trying to get an image to open from its location.... but it keeps trying to open "C:C:example.bmp" instead of "C:example.bmp" does anyone know how to take out the first directory location tag automatically?
Any help will be great!
Thanks.
View 2 Replies
View Related
Jan 3, 2005
There is probably an easy answer to this but I can't find an exact answer searching.
I have an Access 2000 database with the back end stored in a separate location. If I want to move the back end data file to a different location on the computer, how do I change the link (file path)?
The only way I can figure out is to delete all of the old links and relink them from their new location.
Isn't there somewhere that you can just change the path name to the entire back end in one easy step?
Thanks for any help.
View 8 Replies
View Related
Jan 25, 2005
I use the Active X calendar control 10.0 in a number of forms*. The mscal.ocx file is in c:Program FilesMicrosoft OfficeOffice 10.
(*In the calendar's Properties it says it is "MSCAL.Calendar.7", which I think is just MS's way of confusing people.)
After splitting the deploying my app, it appears lots of my users either don't have version 10.0 or it is stored someplace else; for example, in C:WindowsSystem32. Because they don't have the correct version/path, everything crashes.
So, how can I easily determine whether users have the right ActiveX in the correct location?
The Microsoft web site says "To distribute your component as part of a Visual Basic application, you can use Package and Deployment Wizard". I don't have that wizard in my version of Access (2002 SP3 on Windows XP), so that's not an option.
Microsoft also says to "To enter the base address for your component, open the Project Properties dialog box and select the Compile tab. The address is entered in the DLL Base Address box, as an unsigned decimal or hexadecimal integer. The default value is &H11000000 (285,212,672). If you neglect to change this value, your component will conflict with every other in-process component compiled using the default. Staying well away from this address is recommended." It seems to make sense that I put the mscal.ocx in the database's directory on the server to serve as the "base address", but other than that this option scares the heck out of me.
Does someone have any suggestions how to easily ensure users have the right ActiveX version on their computer - and in the correct location? (I'm not a super-coder.)
As always, thanks
Christine
View 3 Replies
View Related
Jun 17, 2005
Hello all,
I have a text box that allows users to type a letter to a customer with a listbox next to it. The listbox is filled with data such as the customer's name, address, etc.... When the user double clicks an item from the list box, it should insert the appropriate data into the text box.
The problem is, is there a way to determine the current cursor location in the textbox so I know where to add the data?
For example, the cursor location has been determined before the text box lost the focus and now i am inserting the apporpriate data:
Textbox = left(TextBox, CursorLocation) & DataFromListbox & right(textbox,len(textbox) - CursorLocation)
Thanks for all your help.
View 1 Replies
View Related
Oct 31, 2005
hi,
can i set the location of my windowform?
i have created a dummy tabstyle form. It exsist out of 3 forms. Those forms are on top of eachother. is there a way that i can lock the windowlocation. for example: form.left = 0
or someting like that?
thanks
View 2 Replies
View Related
Jan 20, 2006
From a command button what would be the code to copy a file from one location to another i.e copy c:datasalesdata.mdb to e:databackupsalesdata.mdb
Jabez
View 1 Replies
View Related
Oct 31, 2007
How I can change the database location? I have a split database. THE LOCATION ARE IN CATABASE1 NOW i WANT IN C:dATABASE2. iKNOW DATABASE UTILITY AND LINK TABLES, BUT FORM SOME RESON i CANT CHANGE. THANKS EVERIBODY FOR YOUR HELP.
View 1 Replies
View Related
Jul 21, 2015
I use Access 2013, and have an Access Database in which one of my Tables is linked to a SharePoint site (SharePoint 2010). The database is in my computer, but I will be required to shift it into another computer onto a network drive. I want to know if doing this will affect the table's link or data exchange between the table and its linked list on SharePoint
View 4 Replies
View Related
Jun 18, 2015
During a system upgrade, our database was migrated to a new server. How do I change Access 2007 to link to the new location instead of defaulting to the old location?
View 2 Replies
View Related
Jul 3, 2013
I have a list of locations in a sub form where a chart has been and the last record is it's current location. I'm generating a building report which should show a list of charts on that building, but it also shows it on old locations. So in the example, it shows for building 43 and building 83. I just need it to show on 83, how to accomplish this.
View 2 Replies
View Related
Nov 3, 2014
running 3 queries together.
1 qry has a date parameter of start/end date(running before the 3 are together)
Have a field in 1 of the 3 queries with a date field that I need to show being <= the date parameter...
How/where do I use this criteria?
View 3 Replies
View Related
Mar 10, 2006
I have a date and time stamp in a Date/Time field of General Date format (3/1/2006 7:52:25 AM).
I wish to select query on the table's Date/Time field by date portion only (3/1/2006) and not include the time portion (7:52:25 AM) of the field.
Using this expression in the query's criteria - "Between [Enter Start Date: (MM/DD/YY Format)] And [End Date: (MM/DD/YY]" will not return the date ranges as desired without also typing in the full time string.
How can the date integer be parsed out and the query properly expression ed on the criteria field without using VB?
View 7 Replies
View Related
Jul 11, 2014
I currently have a query set up which responds and filters by the date.
I use the current code in the criteria on the query for todays date less 7 days
Code:
DateAdd("d",-7,Date())
This works perfectly and I had no problem with it. However I need to adjust the criteria so it is less than 7days ago OR OLDER....
How would I go about doing that?
View 4 Replies
View Related
Apr 26, 2013
I have a query based on a table which has a date field. the field both in the table and the query have the time also in the date value so when I try to query on a date I get nothing if I copy the date and time from the field I will get the result for that record if I just use the date I get nothing. I have tried the format which does display just date but if you click on the field the time is also there You must be able to query for a date only and get all the records.
View 11 Replies
View Related
Jun 21, 2013
A few months ago I created a report that displays the results of a long union query comprising a dozen or so individual queries, each containing an expression that yields a date (or sometimes date and time). I set the report to group by query and then sort by the date expression. Now for some reason that I can't fathom the report has always only ever offered me the option to sort the date "A to Z", I infer it thinks the date is text, but this misunderstanding has never actually stopped it sorting by date perfectly well. It worked. No problems.
However I have recently added formatting to some of the queries so that they just display date, not date and time e.g. Format([dateandtime],"dd/mm/yyyy"), and now the sort by date in the report no longer works. None of the sorting or grouping options have changed, but it now sorts just by the "dd" component of the date - so it thinks 21st June is later than 20th July. why?
View 14 Replies
View Related
