Search results for query: *

The database is used to track publication change requests for numerous technical documents controlled by my department. I have two problems... 1)What's the best way to keep the Request Numbers unique while also ensuring the Sequence# is always 1 higher than the previous record, and starts over...

I'm hoping someone can tell me why my crosstab query has an extra column labeled "<>"? Here's the sql, BTW how do I go about putting it in the pretty little box all you code masters use? TRANSFORM Count(qryDelaysAndCanx.ExType) AS CountOfExType SELECT rqryMonthsAndTails.CalMonth...

I want to be able to change the 'sort by' on a form by clicking on any field's label. I'd like something similar to when using Windows, the clicked label sorts that field and displays an up/down arrow to indicate whether that field is sorted A-Z or Z-A. Thanks! Mike

For each record, I'm trying to get all previous records from the last 20 days where Tail and ATA are same. This SQL works but if there's two records for the same Date, I get 4 records which I understand. I have another field [ExTime] but I don't know how to set the criteria to return records...

My query [qryIssue6_3MoRates] has 3 fields: CalMonth, Issue, 3MoRate. There is 360 records - 24 Months x 15 Issues, with the 3MoRate value for each. qryIssue6: SELECT qryIssue4.CalMonth, qryIssue4.Issue, IIf(Sum([qryIssue4_1].[SRD])=0,0,Sum([qryIssue4_1].[Ex])/Sum([qryIssue4_1].[SRD])*100) AS...

I'm trying to answer a few fundamental/basic questions before I move any further with my application. If anyone has any recommendations, or suggestions where I could go for some insight I would really appreciate it. I have many fields of information that I want to be able to data mine and...

I inherited a database that has most database objects hidden. They show up in database window, but in muted font. What are some of the reasons one would hide the objects (and allow them to be seen at same time)? I've read the help files and can't find any information about when and why to set...

I have a table that captures details about events, tblEvents. A field 'txtDesc' has a description of the event. Within the description is an aircraft tail number. The tail is always 4 digits - the first is "N", and the 3 subsequent characters are numbers between 100 and 999. I've created a...

I have a table that captures monthly data totals for aircraft departures and exceptions. tblData has the following fields: CalMonth, Tail, Exc, SRD CalMonth is Date/Time with each entry entered as first day of month: 1/1/05, 2/1/02.... 12/1/05. (I'm using only 2005 records to help simplify.)...

I'm importing a large table from Excel and many records have a space preceding the first text character. Please help with an expression to delete the first character in a text field if it's a space. And can I use this on a memo field? Thanks! Mike

I have BirthDate field in tblEmpInfo. I need help with an expression that returns all employees that have a birthday in within 3 months of the first day of current month. In my query I created a new field <<BirthMonth: =DateSerial(Year(Date()), Month([tblEmpInfo]![Birthdate]),1)>> and in...

I want to create a form for running an update query which gives the user the choice to update or not update the current record in frmA to the values of record in frmB. If frmB contains more than record (would most likely never be more than 2), the user can select the record to use for updating...

Goal: Ultimately, I'm hoping to end up with a form where user can choose whether to update, delete, or ignore records in one table base on what's in 2nd table. Situation: Analyst downloads data from external system using date and time range criteria. In Access, tblExDwnld is linked to the...